Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hello.
i have a xls with 3 rows with the cell fprmat as time hh:mm example of the values col 1 - nr of hh:mm worked on a day col 2 - nr of standard hh:mm to work on a day col 3 - calcualated - col1 -col2 - it shows if someone has worked more or less then the default time example 08:00 08:00 00:00 ok 09:30 08:00 01:30 ok 07:00 08:00 Problem !!!! - i want here to have -01:00 is this possible? thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating time difference | Excel Discussion (Misc queries) | |||
Calculating Difference in Time (Amt. of Time Transpired) | Excel Discussion (Misc queries) | |||
calculating time difference | Excel Worksheet Functions | |||
calculating difference in time | Excel Discussion (Misc queries) | |||
Calculating time difference | Excel Discussion (Misc queries) |