Time calculation probolem request

  • Thread starter Thread starter joecrabtree
  • Start date Start date
J

joecrabtree

To all,

This is probably a very obvious question, but I cant get my head
around it. I have two cells containing the values 22:01:50 and
22:01:42. When I subtract 22:01:42 from 22:01:50, I get 00:00:08.
Which is fine. However I want the 00:00:08 to just read 8. I.e. just a
normal number. Ive tried formating the cells, but this doesn't work.

Is this possible?

Thanks in advance for your help,

Regards

Joseph Crabtree
 
To all,

This is probably a very obvious question, but I cant get my head
around it. I have two cells containing the values 22:01:50 and
22:01:42. When I subtract 22:01:42 from 22:01:50, I get 00:00:08.
Which is fine. However I want the 00:00:08 to just read 8.
Click to expand...

If 22:01:50 is in A1 and 22:01:42 is in A2, compute:

=round((A1-A2)*24*3600,0)

and format Number with zero decimal places. You can replace 24*3600
with 86400, the number of seconds in a day. The "problem" is: time
is stored as a fraction of a day.
 
You could also try formatting the result cell as

Note: this only changes the display not the underlying value
 
Back
Top