Can anyone tell me if these formulas are accurate?

Total time In/Out: =IF(C4< B4, C4+1, C4)-B4

Total time @ end of pay period: =SUM(D4:D18)*24

http://2.bp.blogspot.com/_ki9lLuCTZ9...preadsheet.JPG

If the results work...

They seem to work, but when the other manager calculates it with the calculator, she gets a different answer... but my formula seems accurate. Does it look accurate to you?

We are experimenting with a new interface and it has some issues. Please don't use the Reply button for follow-up, use the Answer This Question options instead.

What formula does the manager use? What results does she get, How do they differ. The calcs look OK to me.

You formula technique is sound. The only change I would suggest is your formula in D4 should already convert the time values into decimal values.

In D4 and copied down through D18, then formatted as General:

=(IF(C4< B4, C4+1, C4) - B4) * 24

Then in D19 a simple:

=SUM(D4:D18)