As Windows dates and times are actually numbers (just formatted as dates or
times) you can use a normal calculation. Time is expressed as a fraction of
a 24-hour day, thus in your example 23:00 is 0.958333333333333 (try
formatting the cell as General to see this)
So... =A1*24*60 (where A1 holds your time) gives 1380 minutes (not 13800 -
that's 9.58 days <g)
Best rgds
Chris Lav
"Larry H" wrote in message
...
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.
|