<<A1's + B1's Don't Add Correctly>>

[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.
Thanks for any help...

 

[Guest]

If all you want is the hours you could use something like =int(G6*G7*1440

 

[Scooterdog]

This is for figuring overtime, so I do need the minutes.

 

[Scooterdog]

This is for figuring overtime, so I do need the minutes.

 

[Don]

Scooter,

Can't make a lot of sense out of your post but here goes
anyway.

There has to be a better way, but this does work for
extracting the minutes from a time formated cell. First,
format the cell "hh:mm PM" Then highlight the cells you
want to extract the minutes from and use the
Edit/Find/Replace function to extract the space in the
formatting. The data in these cells should now be in this
format.."hh.mm.PM" (or AM whatever the case) Assume your
data starts in A1...Now in A2 put this formula:

=LEFT(RIGHT(A1,7),2)

Drag this down as far as you need.

Adjust as required to fit your data placement.

Cumbersome, but it does work, if that's what your after.

HTH,

Don