Below is a portion of my employer's time statement. As you can see, the idea is to round up the total to 37.00 hrs for the week. But how on earth do they end up with 7.40 hrs, when the start and end times calculate to a different time in reality? Can anyone figure out the formula, or are they just entering these figures manually!
Planned Time
Day Date From To Hours
Sunday 20/01/2002 00:00 00:00 0.00
Monday 21/01/2002 08:30 16:54 7.40
Tuesday 22/01/2002 08:30 16:54 7.40
Wednesd 23/01/2002 08:30 16:54 7.40
Thursda 24/01/2002 08:30 16:54 7.40
Friday 25/01/2002 08:30 16:54 7.40
Saturda 26/01/2002 00:00 00:00 0.00
Cheers
Jake
This message was edited by Jakeyboy on 2002-02-18 02:25
Planned Time
Day Date From To Hours
Sunday 20/01/2002 00:00 00:00 0.00
Monday 21/01/2002 08:30 16:54 7.40
Tuesday 22/01/2002 08:30 16:54 7.40
Wednesd 23/01/2002 08:30 16:54 7.40
Thursda 24/01/2002 08:30 16:54 7.40
Friday 25/01/2002 08:30 16:54 7.40
Saturda 26/01/2002 00:00 00:00 0.00
Cheers
Jake
This message was edited by Jakeyboy on 2002-02-18 02:25