Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DSI Convert Minutes to hours and minutes 1

Status
Not open for further replies.

addicted2

MIS
Jan 16, 2002
16
0
0
AU
Sorry DSI i have realy explained that bad. What I want to do is convert the minutes that I have worked into hours and minutes. I have for example 405 minutes but when I divide that by 60 I get 6.75 What I would like to get is 6.45( 6 hours and 45 minutes) I feel like such a dope.
 
I answered your last post, but I see you started a new one. I think this is what you're looking for.

If you format cell B5 as TIME, then you could use either
=TIME(B3,B4,0)
or
=(B3*60+B4)/1440
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top