time again

[Chas D]

it seems that working with time is more complicated than one would think. i
would like to add a column of hours and minutes, to come up with a total of
hours and minutes.

b1 would be 1.50... 1 hr and 50 minutes
b2 - 4.45
b3 - 7.35
etc.

which should be 14 hours and 17 minutes.

any help would be great appreciated.

[Niek Otten]

All about calculating with times:

http://www.cpearson.com/excel/datetime.htm#AddingTimes

--
Kind regards,

Niek Otten

"Chas D" <mrd4@hotmail.com> wrote in message
news:e6$dEH3DGHA.916@TK2MSFTNGP10.phx.gbl...
> it seems that working with time is more complicated than one would think.
> i would like to add a column of hours and minutes, to come up with a total
> of hours and minutes.
>
> b1 would be 1.50... 1 hr and 50 minutes
> b2 - 4.45
> b3 - 7.35
> etc.
>
> which should be 14 hours and 17 minutes.
>
> any help would be great appreciated.
>