Comparing 2 times stamps?

[BenCrockett]

Hey everyone! Thanks for the help.

I have tried a few things, and unsure of a formula I could do to make this work.

Attached is an example.

I get data pulls of logged in time, and shift start times.

Example in column C the person’s actual login time is there, and column D has their start time. If there's a variance of 'x' how could I have column E display the variance? In this example 15 minutes?
Basically, if there’s a difference between the 2, I need a formula that tells me what difference is.

[Jonmo1]

Should this be shown in Minutes or Time?

If the person was say an hour and a half late, do you want to see 90 or 1:30

This will show it as a TIME value
=MAX(0,C2-D2) <- format cell as a TIME

This will show it as just total minutes
=TEXT(MAX(0,C2-D2),"[mm]")+0 <- format cell as a number.

[BenCrockett]

Minutes, or time, will work, thank you! this helps!

[Jonmo1]

You're welcome.