| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum minutes and seconds to total hours | Excel Discussion (Misc queries) | |||
| How do I convert a number of minutes into hours and minutes? | Excel Worksheet Functions | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| Running Total of Random Number | Excel Discussion (Misc queries) | |||
| Minutes multiplied by a number to give a number | Excel Discussion (Misc queries) | |||
Linear Mode
