Try...
=A1*24*60
....and format the cell as 'General'.
Hope this helps!
In article ,
"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
|