Hi,

If A1 contains the time as hh:mm, use the following formula in some other
cell.
=HOUR(A1)*60+MINUTE(A1)

Regards,
B. R. Ramachandran



"Larry H" wrote:

Hi,

I am using Excel 2000 and have a cell that contains the format of time
(hh:mm) and would like to see the calculation, to put into another cell, that
would produce the exact number of MINUTES in the day that the time represents
ie, 23:00 would equal 13,800 minutes.

I certainly would appreciate guidance on this subject

--
Thanks in advance for your help...

Larry H.