Excel time difference in minutes between date/time

[Trebor8484]

Hi, hoping that someone can assist me with the below please.

This formula calculates the minutes between values in B2 and C2.

=(C2-B2)*1440

What I need to do is calculate if the date and time in C2 exceeds B2 by 16 minutes or more

Thanks

 

[offthelip]

=(c2-b2)>90

 

[Dossfm0q]

Hi like this or

=IF(TRUNC((B1-A1)*1440)>16,"Greater than 16","Less than 16")

'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

Book1
	A	B	C
1	10/3/2020 15:08:00	10/3/2020 15:23:49	Less than 16
2			15:49
3			15:49.12
Sheet1

Cell Formulas
Range	Formula
B1	B1	=NOW()
C1	C1	=IF(TRUNC((B1-A1)*1440)>16,"Greater than 16","Less than 16")
C2	C2	=TRUNC((B1-A1)*1440) &":"&ROUND(CONVERT((((B1-A1)*1440)-TRUNC((B1-A1)*1440)),"mn","sec"),0)
C3	C3	=TRUNC((B1-A1)*1440) &":"&ROUND(CONVERT((((B1-A1)*1440)-TRUNC((B1-A1)*1440)),"mn","sec"),2)

General mm:ss

=TRUNC((B1-A1)*1440) &":"&ROUND(CONVERT((((B1-A1)*1440)-TRUNC((B1-A1)*1440)),"mn","sec"),0)

mm:ss,00

=TRUNC((B1-A1)*1440) &":"&ROUND(CONVERT((((B1-A1)*1440)-TRUNC((B1-A1)*1440)),"mn","sec"),2)

 

[Trebor8484]

Thanks, both solutions work fine