Time Calculating Formula

[zanshin777]

I need a formula which adds Duration (minutes) (on Column C) to time (on column B). (As you see I entered values on column B manually.)

[Jonmo1]

Try

=B2+TIME(0,C2,0)

[Tony Valko]

Here's another one...

Data Range

	A	B	C	D
1	Tasks (Activities)	Start Date	Duration (min.)	Total
2	Shaving	7:00	20	7:20
3	Showering	7:20	20	7:40
4	Wearing	7:40	15	7:55
5	Studying	7:55	240	11:55

This formula entered in D2:

=B2+(C2/1440)

Format as h:mm

Copy down as needed.

[zanshin777]

Thank you very much all.

[Tony Valko]

You're welcome. We appreciate the feedback!