Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
request for time interval worksheet function | Excel Discussion (Misc queries) | |||
Time calculation (Subraction of Idle Time) | Excel Discussion (Misc queries) | |||
Working days and hours calculation - request assistance please! | Excel Worksheet Functions | |||
Ignoring Time in a Date Time Calculation | Excel Worksheet Functions | |||
time calculation with military time | Excel Worksheet Functions |