| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Change 60 minutes to 1 hour
I have a worksheet with a several fields that I place in minutes on
projects. I need to total up the mintues to relect hours. For example: A1 , I have 54 minutes A2 , I have 6 minutes A3 , I have =SUM(A1:A2) How do I get A3 to show total of 1 hour? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Change 60 minutes to 1 hour
One way:
=SUM(A1:A2)/60 If you want the result as an XL time: =SUM(A1:A2)/(60*24) or, equivalently =SUM(A1:A2)/1440 format as time. In article .com, wrote: I have a worksheet with a several fields that I place in minutes on projects. I need to total up the mintues to relect hours. For example: A1 , I have 54 minutes A2 , I have 6 minutes A3 , I have =SUM(A1:A2) How do I get A3 to show total of 1 hour? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change minutes to hours and minutes | Excel Worksheet Functions | |||
| How can I add hours and minutes then multiply by cost per hour? | Excel Worksheet Functions | |||
| convert decimal numbers to a fraction of an hour for payroll hour | Excel Worksheet Functions | |||
| Calculate hour and minutes worked each day | New Users to Excel | |||
| how to change a decimal number (minutes) into hours and minutes? | Excel Discussion (Misc queries) | |||
Linear Mode
