Combining time value, adding % + actual time as a result

[lokocek]

Hello everyone,

A I am not an Excel expert and I would really appreciate your help.

1. What I need to do is to combine few values in one box. It should contain sum of times from previous boxes/columns plus additional values.
So for example: Box A: 3h30mins --> Box B: Time from box A + 20% (result should be 4h12min) --> Box C: Time from box B + 90minutes (5h42mins as a result) --> Box D: 7am + Time from box C (actual time as a result. For example: 12:42 PM).


I know it might look complicated but I tried to explain it as clear as I can. Could anyone please help. Is that even possible in Excel?
My goal is to have a spreadsheet where after typing value in column A I will get results in all other columns.

 

[Special-K99]

Enter time in A1 as hh:mm, ie 03:30, NOT 3h30mins

in B1
=IF(A1<>0,A1*120%<"")

in C1
=IF(A1<>0,B1+TIMEVALUE("01:30:00","")

in D1
=IF(A1<>0,TIMEVALUE("07:00:00")+C1,"")

Format all cells as hh:mm
copy the cells down the page for however many times you are going to enter in column A.