Compare hours difference to total time as number

[Delta729]

Okay, I could really use some help. I'm trying to compare total payroll times that were summed together as a number in one report to another set of data that has as an date/time fields like the following example:

Start End Diff
8/31/2012 6:10 AM 8/31/2012 7:19 PM 13:09:44

The "total payroll" hours were 11.5 hours.

I need to find out how to compare the two in an Excel table. I'm using the formula =IF([@[Total Payroll]]<MOD([@end]-[@start],1), MOD([@end]-[@start],1), "") in my table. This only works if there were NOT any "Total Payroll" hours.
*** Basically, people were working off the clock ***

The result should be 13.16 - 11.5 = 1.66


Any thoughts?

[amit.wilson]

Is it because you haven't subtracted "Total payroll":

Please Login or Register  to view this content.

?

Cheers

[Delta729]

Thanks, I think I have it working.

I needed to extract the time value from the date/time value and then do a difference, multiple the difference x 24.

[Delta729]

Thanks, I think I have it working.

I needed to extract the time value from the date/time value and then do a difference, multiple the difference x 24.