Use custom [mm] formated value that is displayed in a calculation

[WJPS]

How can the custom [mm] formated value that is displayed in a cell be used in
a calculation when it is the result of the difference between two dates
entered as d/mm/yy h:mm

 

[Gary''s Student]

If your date/times are in A1 and A2, then in A3 enter:

=(A2-A1)*24*60

 

[Fred Smith]

Certainly it can. The only problem will be if you have more than 1000
minutes, you can't get Excel to insert commas.

Regards,
Fred.

 

[WJPS]

Thankyou; that works.

If your date/times are in A1 and A2, then in A3 enter:

=(A2-A1)*24*60
--
Gary''s Student - gsnu200857

How can the custom [mm] formated value that is displayed in a cell be used in
a calculation when it is the result of the difference between two dates
entered as d/mm/yy h:mm

 

[Fred Smith]

Glad I could help. Thanks for the feedback.

Regards,
Fred

Thankyou; that works.

If your date/times are in A1 and A2, then in A3 enter:

=(A2-A1)*24*60
--
Gary''s Student - gsnu200857

How can the custom [mm] formated value that is displayed in a cell be
used in
a calculation when it is the result of the difference between two dates
entered as d/mm/yy h:mm