Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
I need to make a sheet, in which i can calculate different ours. The groundschedule is made with (t):mm and lokes like this: =IF(G3=$D$3;0;G3) ex: 15:00 - 05:00 = 14 But I need to calculate how many ours there are ex. from 18:00 to 22:00 and 22:00 to 06:00. like this: ex: 15:00 - 05:00 = 12 | 4 | 7 or ex: 19:00 - 03:00 = 8 | 3 | 5 I hope you understand what i am trying to ask about, and I would be very happy if someone can help me with this litle problems. Kinds H. Nissen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating Difference in Time (Amt. of Time Transpired) | Excel Discussion (Misc queries) | |||
Calculating Regular time, overtime and double time | Excel Worksheet Functions | |||
calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Calculating effective time from start/end date+time | Excel Worksheet Functions |