Times are stored internally in Excel as fractions of a 24-hour day, so
if you see 06:00 in a cell, this will actually be stored as 0.25 (a
quarter of a day). So, if you want to increase a time by 1 hour, you
really need to add 1/24 onto the time. If you want to add one minute,
then add 1/24/60, and for 1 second add 1/24/60/60.

Hope this helps.

Pete

On Nov 1, 5:05 pm, Crackles McFarly wrote:
I've asked before but like a dummy didn't keep the posting.

Please explain in layman terms as this is difficlut to me.
thanks