Converting Times (1 Viewer)

[Scottie31]

I'm trying to convert times to report how certain Employees are doing on their key performaces. How can I subtract 13:00 - 14:00 = -1hr, when doing this all I get is ######? I need to have a value as an answer instead of ######.

Thanks,

 

[CraigDolphin]

use the datediff function

=Datediff("h",TimeField1,TimeField2)

 

[unmarkedhelicopter]

Scottie31, you are NEVER allowed to have a date / time field as a negative number.
13:00 - 14:00 would be negative so ...
Do you just want hours or minutes as well ?
Why would you ever want a negative time ?