Mar 05 2021 09:05 AM
I am trying to create a spreadsheet that changes time from an input column by a specific amount with the result in another column (see screen capture).
(Time entered in Column E is adjusted by 45 minutes and displayed in column F)
Using the TIME function doesn't work but I found that FILL SERIES will work however I have to do each column manually. Is there a way to format the column to do this automatically as each cell is filled?
Mar 05 2021 12:03 PM
You may enter into F2
=E2+45/60/24
after that double click on the dot at right bottom of the frame around the cell; or drag it down
Mar 05 2021 12:03 PM
Enter the following formula in F2:
=IF(E2="", "", E2+TIME(0,45,0))
Fill down from F2 as far as you want.
Mar 10 2021 08:57 AM
Mar 10 2021 09:00 AM
It works for me:
If you use comma as decimal separator, the formula would be
=IF(E2=""; ""; E2+TIME(0;45;0))
Mar 10 2021 09:13 AM
Mar 10 2021 09:15 AM