TEMPLATE FORMULA ISSUE w/rsjenkins

[SUPERFUTURE]

wonderful yearly TMESHEET TEMPLATE submitted by community user: "rsjenkins".
ISSUE: the formula for calculating total time in column E will not calculate
the correct total time from columns B and C when it goes from PM to AM. For
example: time in: 9 PM and time out: 1 AM.....column E calculates the
time as -21 hours. This is incorrect. The correct calculation should
result in total time of 4 hours. Need suggestions on how to fix the formul
formula: telephone: 207.221.5234 THANK YOU FOR YOUR TIME AND ATTENTION

 

[Beth Melton]

Here's the correct formula you need:

=(C5-B5+(C5<B5))*24

For more on date and time calulations take a look at:
http://www.cpearson.com/excel/datetime.htm

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton
What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

Guides for the Office 2007 Interface:
http://office.microsoft.com/en-us/training/HA102295841033.aspx