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

  • Thread starter Thread starter WJPS
  • Start date Start date
W

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
 
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.
 
Thankyou; that works.

Gary''s Student said:
If your date/times are in A1 and A2, then in A3 enter:

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


WJPS said:
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
Click to expand...
Click to expand...
 
Glad I could help. Thanks for the feedback.

Regards,
Fred

WJPS said:
Thankyou; that works.

Gary''s Student said:
If your date/times are in A1 and A2, then in A3 enter:

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


WJPS said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top