Calculating Total Number of Minutes in a Clock Setting

L

Larry H

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
 
B

B. R.Ramachandran

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
 
C

Chris Lavender

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
 
Top