Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating time
I'm creating a timesheet workbook for my employer. "Night
differential" is paid from 1800 to 0600. "Regular pay" applies to the rest of the day. We have to show time spent on various job tasks across a day. Beneath each tsak are cells labeled "start" and "stop." Each task lists 3 to 4 "start"/"stop" periods. The only way I've worked out to calculate "night differential" is to "start" or "stop" exactly at 1800 or "start" or "stop" at 0600. Is there a way to make excel seperate night differential from regular pay if a "start" time listed, for example, 1700 and had a "stop" time of 1900? bafa |
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 |