Adding times

[Brutium]

Hello everyone,
I am trying to help my wife with a schedule she is making, but all attempts at adding times have gone the wrong way.
Let me explain what I need to do.

Let say that in cell A3 I have a start time of the format e.g. 10:30, and to this I would like to add 3.5 hours. What I need to accomplish, is to get in cell C3 the time 14:00.

How do I accomplish this?

Tank you in advance for any help you can give me.

 

[JoeMo]

Excel Workbook
	A	B	C
2	Time	add (hrs)	Get
3	10:30	3.5	14:00
Sheet1

 

[Brutium]

Thank You JoeMo, that is exactly what I was trying to accomplish. My mistake was that I was using the wrong number format in the cell, and I was not dividing the time I was inputting by 24.

Again thank you

 

[Brutium]

Hello JoeMo,
Still me...

I was wondering if you could help me further.

I have the following:

[TABLE="class: grid, width: 500"]
<TBODY>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Hrs. of Work
[/TD]
[TD]Time in
[/TD]
[TD]Time out
[/TD]
[TD]Client's name
[/TD]
[TD]Travel Time
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]3.5
[/TD]
[TD]8:30
[/TD]
[TD]12:00
[/TD]
[TD]George
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]12:30
[/TD]
[TD]14:30
[/TD]
[TD]Mary
[/TD]
[TD]30 min
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]2.5
[/TD]
[TD]15:00
[/TD]
[TD]17:30
[/TD]
[TD]Mark
[/TD]
[TD]30 min
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]


I need to add 30 min. travel time to the time I get in C2,3,4,etc. so that automatically fills the B3, B4 B5 etc.
My problem is writing the 30 min in cells E3, E4, E5 etc. If I write it as 0.5/24 to give me 30 min. the cell comes back as 0.02 which does not add as the 30 minutes of the hour I need in cells B2, B3 etc.

Do I make sense?

 

[T. Valko]

Hello JoeMo,
Still me...

I was wondering if you could help me further.

I have the following:

[TABLE="class: grid, width: 500"]
<TBODY>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Hrs. of Work
[/TD]
[TD]Time in
[/TD]
[TD]Time out
[/TD]
[TD]Client's name
[/TD]
[TD]Travel Time
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]3.5
[/TD]
[TD]8:30
[/TD]
[TD]12:00
[/TD]
[TD]George
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]12:30
[/TD]
[TD]14:30
[/TD]
[TD]Mary
[/TD]
[TD]30 min
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]2.5
[/TD]
[TD]15:00
[/TD]
[TD]17:30
[/TD]
[TD]Mark
[/TD]
[TD]30 min
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]


I need to add 30 min. travel time to the time I get in C2,3,4,etc. so that automatically fills the B3, B4 B5 etc.
My problem is writing the 30 min in cells E3, E4, E5 etc. If I write it as 0.5/24 to give me 30 min. the cell comes back as 0.02 which does not add as the 30 minutes of the hour I need in cells B2, B3 etc.

Do I make sense?

Do you mean you need to add 30 mins to the total in column A if column E has an entry?

 

[Brutium]

What I need is to add 30 minutes to each cell in the B column if there is an entry in the E column.

 

[T. Valko]

What I need is to add 30 minutes to each cell in the B column if there is an entry in the E column.

You would need to add it to a different column.

=B2+IF(E2="",0,TIME(0,30,0))

 

[Brutium]

T.Valko, JoeMo,

Thank you to the both of you.
I modified the spreadsheet to accommodate T.Valko's suggestion and it works fine, the only problem now is that I am not sure on how to go about to add my minutes so that it would come back as hours. I tried to use the formula =SUM((E6:E11)/24) where E6:E11 is the total of 30 minutes I have in the E column, but when I sum it up, it comes back with a #VALUE! error.

Why?

 

[T. Valko]

T.Valko, JoeMo,

Thank you to the both of you.
I modified the spreadsheet to accommodate T.Valko's suggestion and it works fine, the only problem now is that I am not sure on how to go about to add my minutes so that it would come back as hours. I tried to use the formula =SUM((E6:E11)/24) where E6:E11 is the total of 30 minutes I have in the E column, but when I sum it up, it comes back with a #VALUE! error.

Why?

Are you entering just the number 30 or are you entering the string 30 mins?

Just enter the number 30.

If this is your data:

Book1
	E
6	30
7	_
8	30
9	30
10	_
11	30
Sheet1

What result do you expect?

 

[Brutium]

I am entering the number 30, NOT the string. What I expect is the number of hours and minutes that all the 30 minutes add up to. In a different cell I am collecting these values so that I may add them up together with the number of hours worked so that my wife can be paid not only for the work time but also the travel time. So if she works 6 hours in a day and she has a 2:30 travel time, the company will have to pay her 8:30 hours all together.