ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Adding time & dates together (https://www.excelbanter.com/excel-programming/379079-re-adding-time-dates-together.html)

Trevor Shuttleworth

Adding time & dates together
 
08/12/2006 11:36:00 + 36:00:00 = 09/12/2006 23:36:00

Regards

Trevor


"TheRook" wrote in message
...
I currently have a cell populated with a date and time in the following
format, custom dd/mm/yyyy hh:mm. This is the start time of an operation,
the
operation is 36 hours. I want to be able to add the operation time to the
start date to calculate an end date, and result in the same format.

How do I do it?





All times are GMT +1. The time now is 06:55 AM.

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