Adding Time

**Maeeday** · 08-11-2012, 03:18 PM

I need a formula for adding time. Example An employee clocks in at 5:30AM and must take lunch before the 5th hour. What time does the employee need to take lunch by? I have a spread sheet with cell A2 = 5:30AM, B2 = 5, C2 = Here's where I need the formula... A2+B2....

Help, please!

**Pepe Le Mokko** · 08-11-2012, 03:20 PM

Try =A2+B2/24 and format as time

**dilipandey** · 08-11-2012, 03:23 PM

Hi Maeeday,

Welcome to the forum.

You can use below formula:-

Formula:

=TIME(HOUR(A2)+B2,MINUTE(A2),SECOND(A2))

Regards,
DILIPandey

<click on below 'star' if this helps>

**Maeeday** · 08-11-2012, 03:52 PM

Yes! Thank you!!!

**dilipandey** · 08-11-2012, 04:09 PM

you are welcome Maeeday...

Cheers

Suggest you to mark this thread as [SOLVED]. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**Maeeday** · 08-11-2012, 04:59 PM

How do I post as solved?

**jeffreybrown** · 08-11-2012, 05:15 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save