View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
joecrabtree joecrabtree is offline
external usenet poster
 
Posts: 111
Default Time calculation probolem request

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