Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=hour formula
I have summed up the total time, e.g 34:40. Needed to split this into 2 cells
for hours and minutes. I used the =minute formula which worked fine but the =hour formula only showed 10hrs. How function can I use to show 34hrs? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=hour formula
=INT(A1*24)
"Karen" wrote: I have summed up the total time, e.g 34:40. Needed to split this into 2 cells for hours and minutes. I used the =minute formula which worked fine but the =hour formula only showed 10hrs. How function can I use to show 34hrs? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=hour formula
With Total time in A1 try the below..
=VALUE(TEXT(A1,"[h]")) If this post helps click Yes --------------- Jacob Skaria "Karen" wrote: I have summed up the total time, e.g 34:40. Needed to split this into 2 cells for hours and minutes. I used the =minute formula which worked fine but the =hour formula only showed 10hrs. How function can I use to show 34hrs? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=hour formula
Thank you Jacob, this solved my problems. :)
"Jacob Skaria" wrote: With Total time in A1 try the below.. =VALUE(TEXT(A1,"[h]")) If this post helps click Yes --------------- Jacob Skaria "Karen" wrote: I have summed up the total time, e.g 34:40. Needed to split this into 2 cells for hours and minutes. I used the =minute formula which worked fine but the =hour formula only showed 10hrs. How function can I use to show 34hrs? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting from 12-hour to 24-hour format | Excel Worksheet Functions | |||
How do I set up a formula for parts (or units) per hour? | Excel Worksheet Functions | |||
convert decimal numbers to a fraction of an hour for payroll hour | Excel Worksheet Functions | |||
Formula for Hour Minute and Second | Excel Worksheet Functions | |||
How can I round an hour to the nearest 1/4 hour? | Excel Worksheet Functions |