Home |
Search |
Today's Posts |
#1
|
|||
|
|||
convert minutes into hours:minutes
I have 4 columns across the page that my staff needs to enter the number of
minutes they spend on a task. I then want to add the total number of minutes and convert it to hours:minutes. What formula would I use to get the correct formatting? Example: A1 = 25, B1 = 15, C1 = 45 Total minutes spent = 85 Desired Result is 1:25 (1 hour 25 minutes) |
#2
|
|||
|
|||
Hi
=SUM(A1:C1)/(24*60) and format as time -- Regards Frank Kabel Frankfurt, Germany tlf713 wrote: I have 4 columns across the page that my staff needs to enter the number of minutes they spend on a task. I then want to add the total number of minutes and convert it to hours:minutes. What formula would I use to get the correct formatting? Example: A1 = 25, B1 = 15, C1 = 45 Total minutes spent = 85 Desired Result is 1:25 (1 hour 25 minutes) |
#3
|
|||
|
|||
There are 1440 minutes in 24 hours, so:
=(A1+B1+C1)/1440 format as time. HTH. Best wishes Harald "tlf713" skrev i melding ... I have 4 columns across the page that my staff needs to enter the number of minutes they spend on a task. I then want to add the total number of minutes and convert it to hours:minutes. What formula would I use to get the correct formatting? Example: A1 = 25, B1 = 15, C1 = 45 Total minutes spent = 85 Desired Result is 1:25 (1 hour 25 minutes) |
#4
|
|||
|
|||
=(A1+B1+C1)/1440
and make sure the target cell is formatted a time. -- HTH RP (remove nothere from the email address if mailing direct) "tlf713" wrote in message ... I have 4 columns across the page that my staff needs to enter the number of minutes they spend on a task. I then want to add the total number of minutes and convert it to hours:minutes. What formula would I use to get the correct formatting? Example: A1 = 25, B1 = 15, C1 = 45 Total minutes spent = 85 Desired Result is 1:25 (1 hour 25 minutes) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
How do I convert times from hours to minutes? | Excel Discussion (Misc queries) | |||
convert seconds to minutes and seconds | Excel Worksheet Functions | |||
How do I convert minutes to hours:minutes? | Excel Worksheet Functions | |||
Minutes to seconds - how to convert? | Excel Worksheet Functions |