ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I add numbers to time? (https://www.excelbanter.com/excel-worksheet-functions/192000-how-do-i-add-numbers-time.html)

trob

How do I add numbers to time?
 
How do I add numbers to time? I have a start time in time format of 7:30 a.m.
I calculate a project will to 4.25 hours, in general number format, i.e., 4
hours and 15 minutes. When I add the two, it does not give me 11:45 a.m., but
instead it still shows 7:30 a.m. I tweaked with the format in the results
cell to no avail.

Dave

How do I add numbers to time?
 
Hi,
When you add numbers to time, XL treats those numbers as days, so you need
to divide by 24 if you want hours.

If 7:30 AM is in A1...
=A1+(4.25/24)
Format like A1

Regards - Dave.


All times are GMT +1. The time now is 10:09 AM.

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