Calculating Total Number of Minutes in a Clock Setting
 

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.

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.

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

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.