=TEXT(G25-F25,"h:mm") this is the formula I am working with... Thanks again.

"Ted Metro" wrote:

Can you post the formula you're using, and the formula that's creating the
error? That sounds like an easy fix...

"shaggy78" wrote:

I am trying to create a spreadsheet that calculates difference in times.
however if I have someone come in early it says in the box ###Num###.
Ex..
Clocked In Time of Run
7:54 8:00
8.:03 8:00
7:52 8:00
8:06 8:00

I need to run the same formula if there is overtime or if they are late. Can
someone help me please......

Thanks....