S
Scooterdog
In my worksheet I entered:
A B D G
1 11:00 08/01/2004 38200.458 =D2
2 15:50 08/01/2004 38200.66 10:58
3 21:00 08/01/2004 38200.875 =G2+G3
4 23:00 08/01/2004 38200.958 =D5
5 12:00 =G5-G4
6 =18.75/60
7 =G6*G7*1440
8 Here is Problem: Need 19 Total is 19.375
9 $1.46
10 Total is 28.38
The correct answer I need is: 27.74
In G8, I have tried rounddown with no luck. What
function is correct for this?
Also, rounddown does not give correct answers when
changing times.
This is a overtime worksheet. I need both hours and minutes.
Thanks for any help...
A B D G
1 11:00 08/01/2004 38200.458 =D2
2 15:50 08/01/2004 38200.66 10:58
3 21:00 08/01/2004 38200.875 =G2+G3
4 23:00 08/01/2004 38200.958 =D5
5 12:00 =G5-G4
6 =18.75/60
7 =G6*G7*1440
8 Here is Problem: Need 19 Total is 19.375
9 $1.46
10 Total is 28.38
The correct answer I need is: 27.74
In G8, I have tried rounddown with no luck. What
function is correct for this?
Also, rounddown does not give correct answers when
changing times.
This is a overtime worksheet. I need both hours and minutes.
Thanks for any help...