Hello,
I am having trouble with a timesheet I’m working on. Depending on the employee’s shift I need Excel to calculate the difference between midnight and a PM time or midnight and an AM time. I am looking for a formula that will return a positive value whether the time is AM or PM.
Thanks,
Marc
Last edited by MarcLiq; 10-03-2009 at 04:02 PM.
Not entirely clear but assuming shift duration never exceeds a total of 24 hours then
=MOD(endtime-starttime,1)
format to time
which will work regardless of midnight being crossed.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks