8:45AM - 8:50AM = 15?? Help

[Newbie2012]

Sorry, I meant 8:50AM minus 8:45AM = 15...(am trying to get the result of 5 minutes...)

I've used a few example formulas including this last one:

OnSiteTimeMins: (60*Format([Depart Job]-[Arrive Job],"h")+(Format([Depart Job]-[Arrive Job],"nn")))

And it keeps returning with 15?? or 00:15?

The field datatypes are medium time

I must be definitely missing something...:banghead:

 

[Newbie2012]

So sorry, I am referencing the wrong fields...duh

Problem solved, light is on...

 

[Frothingslosh]

Don't worry, we've all done something like that.

Some of us may have just accidentally overwritten first names with last names yesterday with a new update query. No idea who that could be, though.