Time Subtraction

**realniceguy5000** · 09-25-2009, 01:34 PM

I have a workbook that is generated from the system(AS400)but it wont subtract the time finish -time start.

I get a #Value error in the cells I tried two different formulas

Can someone take a look at it and see what might be the problem?

Thank You, Mike

**DonkeyOte** · 09-25-2009, 01:47 PM

You will need to revise the delimiter from period to colon, eg:

=MOD(SUBSTITUTE(J2,".",":")-SUBSTITUTE(I2,".",":"),1)
(format as [h]:mm:ss)

Multiply by 24 if you want the above in decimal hourly form

**realniceguy5000** · 09-25-2009, 01:56 PM

Originally Posted by DonkeyOte

You will need to revise the delimiter from period to colon, eg:

=MOD(SUBSTITUTE(J2,".",":")-SUBSTITUTE(I2,".",":"),1)
(format as [h]:mm:ss)

Multiply by 24 if you want the above in decimal hourly form

Thanks Again...

You have been a great help today...

Mike