Forum Discussion
Adding integers to Date&Timd
2 2/4/22 1pm 2/4/22 3pm 1 2/4/22 3pm 2/4/22 4pm 2 2/4/22 4pm 2/4/22 6pm 2 2/4/22 6pm 2/4/22 8pm I would like to know is there a formula to add the integers in Col 1 to Col ...
To add a # hours to a date you just need to divide by 24 and add:
=A1/24 + B1
then in B2 you can either use that same formula or use =C1
=A1/24 + B1
then in B2 you can either use that same formula or use =C1
BTW you then just fill down. If you already have col A then if you hover over the bottom right corner of cell B2 you will get a large "+" icon and can likely just double-click and it will auto-fill down and then do the same for cell C1. If double-click doesn't work for some reason you can get that same large "+" and drag down or highlight the cell and use CTRL-D to fill down