=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? |
=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? |
=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? |
=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? |
All times are GMT +1. The time now is 09:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com