how do I add 2.5 hours to a column of data

[Lisa Hetherington]

right now I have one column (C) of data with a custom format of

h:mm AM/PM

I would like to create a D column of column C plus 2.5 hours

how do I format this?

....Lisa

 

[Earl Kiosterud]

Lisa,

The formula would be
=C2+TIMEVALUE("2:30:00")

It will probably automatically apply some inappropriate date-time format. Do Format -
Cells - Number tab - Time, and select the time format you want.

 

[Pete_UK]

You need to realise that time is stored by Excel as a fraction of a 24-
hour day, so 12 hours is stored internally as 0.5, 6 hours as 0.25
etc. So, to add 2.5 hours onto a time, you must convert the hours into
the same format by dividing by 24, thus:

=C1+2.5/24

The result will probably take the same format as that in C1 - you
might like to use a custom format of [h]:mm, which will stop the wrap-
around of hours if the total is greater than 24.

Hope this helps.

Pete

 

[Lisa Hetherington]

That works!!

Thanks Earl

....Lisa

Lisa,

The formula would be
=C2+TIMEVALUE("2:30:00")

It will probably automatically apply some inappropriate date-time format.
Do Format - Cells - Number tab - Time, and select the time format you
want.