Converting a number to hours and minutes

D

dslocum

Sorry, but I couldn't find exactly what I was looking for in an
previous thread.
I am using Excel 2007 on a Vista Business box.

I need to simply convert a raw number of minutes into Hours:Minute
format.
We want to monitor the length of time spent on paticular task
throughout the day. From a drop-down list the end-user selects th
Task Category and then Tabs to the adjacent cell and manually enter
the number of minutes it took to perform the task. The end-use
repeats this process throughout the day for each task.
I have use a SumIf function to track the total number of minutes fo
each task available on the drop-down listing. I need to convert thes
SUMs to hh:mm. Example: 120 minutes would return 2:00 and 126 woul
returen 2:06. Likewise, 45 would return 0:45.
Is this possible?

d
 
A

Alan

Divide the minutes by 1440 and format the cell as Time,

=126/1440 formatted as time = 2:06

Regards,
Alan.
 
D

Dave Peterson

You can use another cell to convert minutes to time.

=a1/60/24
and give it a nice number format (hh:mm:ss)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting time to Minutes 2
Converting hour/minutes to hours/hundredths 1
Convertin hours into days, hours and minutes 6
Hours and sum of hours 2
Converting hours to minutes 5
Hours to minutes jcs 5
Converting Seconds to Hours, Minutes, Seconds 3
Convert figures to Hours and minutes 4

Top