Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Sheet Problems in Excel
My objective is: Total hours per day with an employers form structured as
start time cell, end time cell, minus lunch time cell, equals total hours. The respective e.g. is B1-A1-C1=D1. Time formating not an issue in A1 or B1. Negative symbol being displayed unsuccessful in lunch time cell C1 with number format though it is an option. Too scared to try the calendar switch to 1904 and I don't understand how the calendar would create a negative symbol option to work. If lunch were always a constant amount of time or number I think I could struggle through a round-robin formula of some sort. It doesn't really matter if the D1 cell reflects time worked with the colon symbol or decimal, whatever makes it all work. Ofcourse none of this would be an issue if the employer would use a 24hr clock representation instead of the am/pm nonsense. I don't know that excel 2002 can even do this "don't rock the employer boat" calculation. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems with time format in excel | Excel Worksheet Functions | |||
Veiwing excel sheet in IE problems. | Excel Discussion (Misc queries) | |||
Problems Creating html files with excel sheet | Excel Discussion (Misc queries) | |||
Problems Autosaving an excel file/sheet as Text | Excel Discussion (Misc queries) | |||
Am trying to make a time sheet and having problems with a formula. | Excel Worksheet Functions |