ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excel (https://www.excelbanter.com/excel-discussion-misc-queries/2832-excel.html)

The Admiral

excel
 
How do I add hours and minutes?

Gordon

The Admiral wrote:
How do I add hours and minutes?


To what?



Bob Phillips

Just format the c ells as time and add them .

--
HTH

-------

Bob Phillips
"The Admiral" <The wrote in message
...
How do I add hours and minutes?




Chip Pearson

Times are stored as a fraction of a 24-hour day (06:00 = 0.25,
12:00 = 0.5, 18:00 = 0.75, etc), so you can add them as you would
ordinary numbers.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"The Admiral" <The wrote in
message
...
How do I add hours and minutes?





All times are GMT +1. The time now is 07:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com