Time flys when ur having fun with time sheets.
Please help. It's been seriously 5 hours since I started this task.
All I want to do is know the function to calculate the total hours worked per day given a start and finish time.
Then to calculate the total hours worked that week.
I have attached my 72 hour (to create) masterpiece as I am not finding that I am having any success and I'm losing it!!!
NOT COPING AT ALL
Last edited by bimbo279; 07-22-2007 at 12:34 PM. Reason: would like to attach something like a zip haha too clever
Suggest in F12 use =E12-D12 & format cell as h:mm
In E19 use custom formatting as [h]:mm this will display as 38:00
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
duplicate - see here
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks