Live Chat Software by Kayako |
Knowledgebase: Microsoft Excel
How do I add a number of hours and minutes to a date?
Posted by - NA - on 28 March 2006 05:48 AM
|
|
Solution: Suppose your date is in A1 and you want to add 3 hours 15 minutes 10 seconds to this date, with the result in B1. Set B1 to =A1+TIME(3,15,10) Also, you could enter "3:15" in cell C1, and set B1 to =A1+C1. | |
|
Comments (0)