Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating time
i have a problem when wanting to calculate time using 24 hour clock, i have
attached a simple example: These are the columns & row 1: A B C D E Start Finish Time of break Break length Hours 8:00 18:00 13:00 1.00 9.00 23:00 7:00 2:00 1.00 ERROR I want to be able to use it for night time hours, the example that is there, I want to calculate from 11pm to 7am, with 1 hour break at 2am, how can I do this? The formula that i am using is as follows: Format of cells is 13:30 =IF(B1-A1<0,"ERROR",((B1-A1)*24)-D1) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Response Time | Excel Discussion (Misc queries) | |||
calculating time | Excel Discussion (Misc queries) | |||
help with calculating overtime in a time sheet | Excel Discussion (Misc queries) | |||
Calculating a rate for elapsed time? | Excel Discussion (Misc queries) | |||
Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions |