| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem where end time is less than start time
Hi, I use start and end time data to fill staff resource. I want to build in some error capture where the end of the duty is less than the value of the start of the duty. However, on occasion we have staff starting at 22:00 and finishing at 06:00. This would result in an error although the duty is legitimate. How can I get around this issue? kind regards, Matt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
| calculate hours using start time & end time, excluding weekends | Excel Programming | |||
| Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
| template or formula for start time -finish time -total hours ple | New Users to Excel | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Threaded Mode
