Formula to add 24 hours in the time

[Jomejorada]

Hello,

I would like to format a column that will automatically 24 hours to the time. Please see attached.

Thank you in advance,

Jocelyn

[anghicole]

Like this?

[Jomejorada]

Yes but Snook already sent me the formula. Thanks!

[The_Snook]

Hi Jomejorada,

Try this in cell D2 and copy it down:

=ROUNDUP(A2,-2)+B2

Regards,

Snook

[Jomejorada]

Hi Snook,

I'm finding that there are some that give incorrect results using the same formula. Please see attached for examples.

Thank you,
Jocelyn

[Jomejorada]

I used the RoundUp formula and it worked on some but not on others? Attached.


Please help.

Thanks,
Jocelyn