MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Ok so final outcome is...


Posted by ycram1 on June 21, 2001 9:43 AM


Ok so is this right then? This is for billing purposes I just don't want any questions asked. I appreciate your help though.

Rate p/h $2.00

June 18, 2001
Time In Time Out Total Hours Total $ Daily
6:30 AM 3:10 PM 8:40 17.33

June 19, 2001
Time In Time Out Total Hours
6:30 AM 4:50 PM 10:20 20.67


Posted by Mark W. on June 21, 2001 9:47 AM

Looks OK to me...

=("4:50 P"-"6:30 A")*24*2 is indeed 20.67

Posted by ycram1 on June 21, 2001 9:50 AM

Thank you very much..Can you tell I'm a blonde? :)

Posted by Mark W. on June 21, 2001 10:00 AM

No, I wasn't thinking that...

You'd be surprised how many people struggle with
time conversions is Excel. The important this to
remember is that Excel stores date/time values
as fractional parts of a day. 8 hours and 40
minutes is 0.361 of a day. To get from days to
hours you must multiply by 24...

(days)*(hours/day)*($/hour)

The days "cancel out" and so do the hours leaving
just dollars. Obviously, if you multiply
(days)*($/hour) you can simplify the units and
you get an "apples and oranges" kinda thing
going on! : ) : Looks OK to me... : =("4:50 P"-"6:30 A")*24*2 is indeed 20.67

Posted by Mark W. on June 21, 2001 10:10 AM

Re-Post with Typos Corrected