=hour formula

K

Karen

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?
 
J

Jacob Skaria

With Total time in A1 try the below..

=VALUE(TEXT(A1,"[h]"))

If this post helps click Yes
 
K

Karen

Thank you Jacob, this solved my problems. :)

Jacob Skaria said:
With Total time in A1 try the below..

=VALUE(TEXT(A1,"[h]"))

If this post helps click Yes
---------------
Jacob Skaria


Karen said:
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?
 

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

Top