Converting a number to Hour & Min format

M

Morgan

I am attempting to take a basic number, say 2000, and convert the number into an hour and minute format (i.e. 33:33) only. Everytime I use the custom format tab or the time/date tab I get a date included or an AM/PM setting. Any ideas or suggestions? Thanks in advance.
 
S

saziz

Hi,
For any number to be converted into time format you need to divide tha
number by 24, since Excel time code is 24 (hr) code. then you forma
the divided answer (83.33) into time, you will get 8:00
regards
sazi
 
M

Morgan

This was helpful, but perhaps I'm still not grasping the concept fully. Lets say I have several cells and I have them as 50, 7, 13, 15, 3, and 9. I want add these up but I want to total them in hours and minutes format. I need the numbers (i.e. 50, 7, 13) to be listed as is and do not wish them to be listed in decimals or anything else. I am attempting to calculate minutes (seconds are dropped) on a tardy spreadsheet and needing them to be calculated in an hour and minute format. I appreciate your reply and look forward to hearing back from you.
 
J

JE McGimpsey

If your numbers (50, 7, 13,...) are minutes, then sum them and divide by
24*60:


=SUM(A1:A6)/1440

formatted as time.
 
Top