Comparing [m]:ss to integer minutes

[Plasmech]

I have a need to compare a cell that is formatted in [m]:ss to one that is formatted in integer minutes ("Number" with 0 Decimal places).

The comparative statement will be in an IF function.

What would the best way to go about this be?

Thanks for any help.

 

[Scott Huish]

=IF((A1*1440)=B1,"YES","NO")

 

[awoohaw]

try this:

=IF(INT(A2*(60*24))=C2,"Yes","No")

Book1
	A	B	C	D	E
1	Time in [h]:ss	portion of day	minutes	seconds	Compare Minutes in time to minutes as integer.
2	51:21	0.03566	51	21	Yes
3	52:57	0.036771	52	57	Yes
4	31:22	0.021782	31	22	Yes
5	27:33	0.019132	27	33	Yes
6	36:30	0.025347	36	30	Yes
7	32:49	0.022789	32	49	Yes
8	45:28	0.031574	45	28	Yes
9	53:46	0.037338	53	46	Yes
10	33:40	0.02338	33	40	Yes
11	40:28	0.028102	40	28	Yes
12	33:44	0.023426	33	44	Yes
13	56:20	0.03912	56	20	Yes
14	26:07	0.018137	26	7	Yes
15	24:41	0.017141	24	41	Yes
16	48:06	0.033403	48	6	Yes
Sheet1

Cell Formulas
Range	Formula
B2:B16	B2	=A2
C2:C16	C2	=INT(B2*(60*24))
D2:D16	D2	=MOD(B2*(60*24),1)*60
E2:E16	E2	=IF(INT(A2*(60*24))=C2,"Yes","No")

 

[Plasmech]

=IF((A1*1440)=B1,"YES","NO")

Thanks. For the second time in less than a week, I am reminded that the fundamental time unit in Excel is the day.

 

[awoohaw]

Thanks. For the second time in less than a week, I am reminded that the fundamental time unit in Excel is the day.

I learn and relearn and am reminded of things nearly every day.

In this situation I think you still need to round down or use the INT function to get exact minutes per your requirement.