Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to calculate no. of hours under different circumstances.
3 situations would be as follow, i set the formular like this is =IF(B1<A1,
24/24-A6+B6,B6-A6), both A & B using time format and C using number format. A B C Start Time End Time No. of hours 10:30 15:00 4.5 00:00 08:00 8.0 08:00 23:59 16.0 **Problem** I can get the result for the first 2, but not the last one, any one can help, many thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate Hours and overtime by week | Excel Worksheet Functions | |||
How do I calculate hours in Excel | New Users to Excel | |||
calculate hours just can't figure it out | Excel Worksheet Functions | |||
calculate difference in time to hours | Excel Worksheet Functions | |||
calculate average hours and minutes | Excel Worksheet Functions |