jzuber said:Hi Yogi!
You are amazingly patient.
My start time -- right off the time clock = 15:84
My end time = 0:23
You're right that this should be easy. I can't seem to just enter 15:84. No matter how I format the cell, when I enter 15:84 (or anything else with a colon), it gives me a decimal. (ie., 15:84 becomes .633333).
I can do the math in my head faster than this!
Thanks for your help.
JAZ
Book1 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | StartTime | 15.84hour | 07-Aug-03 | Given | ||||
2 | EndTime | 0.23hour | 08-Aug-03 | intermediarycomputation | ||||
3 | 0.34958hour | workTimeindays | resultsinHoursandMinutes | |||||
4 | 8:23 | workTimeinHoursandMinutes | resultinHoursandfractionsofanhour | |||||
5 | 8.39 | workTimeinHoursandfractionsofanhour | ||||||
6 | ||||||||
Sheet1 |
jzuber said:Yogi:
I'm making progress on this -- I know that's kind of hard to believe. I understand B1, B2, B3 and B5 in your simulation. I understand the results in B4, but I can't figure our what formula created this result.
If I'm reading the simulation correctly, it says b4=b3. Is this a formatting issue or am I missing a formula?
Clearly I've missed the boat already! Once again, thanks for your help.
JAZ
Hi Brian:Brian from Maui said:....
Since I'm always butting in ....