View Single Post
  #3   Report Post  
Domenic
 
Posts: n/a
Default

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