Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
excel timesheet help
Name: Natalie (by wondrwoman92) Date: April 26, 2006 at 13:22:24 Pacific OS: windows xp (i think) CPU/Ram: unknown Product: dell
Comment:
I am trying to create a timesheet for my work. Has time-in/time-out/minus-lunch/hours-worked columns. Can't get hours worked column to subtract the lunch period (entered in minutes). Also, I can't get it to do a row of subtotals underneath each week. I'm obviously just learning all this formatting stuff, but I would greatly appreciate any help. Thanks! Natalie
Summary: I built an Excel timesheet many years ago and I understand the difficulty of time conversions. The trick is to use the HOUR and MINUTE functions to extract the number of hours and the number of minute...
Summary: Grok, I agree and have looked into it's use many failed times. I must have some kind of mental block for it. I just finished analyzing your formula in regards to Tony's query for the purpose of under...
Summary: I'me having nightmares in getting an excel based timesheet to work properly. Does anyone out there have a working timesheet file they'd be prepared to let me have? Thank you very much for your help D...