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
