Adding time (more than 24 hours) to date time stamp

**sidapt** · 05-30-2012, 04:36 AM

Hello everyone !

I want to add hours to a date-time cell to get result in date-time.

Format of cell A1 is d/m/yy h:mm AM/PM
Format of cell A2 is General
Format of cell A3 is d/m/yy h:mm AM/PM

I want to add A2 (number of hours) to A1 to give A3.
The formula I used is A3=A1+Time(A2,0,0)
The formula works perfectly fine when A2 is less than 24, but when A2 is more than 24, the date doesn't get changed.

Please help, can I use someother formula or change format of A2 !!

**Bob Phillips** · 05-30-2012, 04:39 AM

Try this

=A1+INT(A2/24)+TIME(A2,0,0)

**sidapt** · 05-30-2012, 06:51 AM

Thanks a ton Bob ! It worked like a charm !!

**Roundo** · 01-04-2014, 05:59 AM

how can i do this with 8 hours a day instead of 24 hours of day..

**Pepe Le Mokko** · 01-04-2014, 08:04 AM

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

**SC Jangra** · 01-06-2014, 02:43 AM

I want gantt chart in hour & date for example I have travel from origin point to destination will take 4 days , 1st day I will reached B point 9:00hrs and next day i will reached at C point 14:00 which was planned. but I unable to make gantt chart. can you help me provide the such type gntt chart

**Pepe Le Mokko** · 01-06-2014, 04:08 AM

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.