I want to take a start date/time and increment it 36 hours.
I tried splitting the date and the time into two different cells and incrementing the date if the time goes past midnight, but that got too complicated.
Is there an easier way to do it?
5/1/2014 8:30 AM -> 5/2/2014 8:30 PM
dvick, good afternoon.
Format A1 and C1 as DATE --> dd/mm/aaaa hh:mm AM/PM
Then:
A1 = 05/01/2014 08:30 AM
B1 = 36:00
C1 --> = A1 + B1
C1 --> = 05/02/2014 08:30 PM
Is this what you want?
I hope it helps.
...If my answer helped you, Please, click on. * Add Reputation (at left)
Best regards.
Marc?lio Lob?o
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks