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

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

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

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

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


"WJPS" wrote:

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

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

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" wrote in message
...
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

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

Thankyou; that works.

"Gary''s Student" wrote:

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

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


"WJPS" wrote:

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

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

Glad I could help. Thanks for the feedback.

Regards,
Fred

"WJPS" wrote in message
...
Thankyou; that works.

"Gary''s Student" wrote:

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

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


"WJPS" wrote:

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