Excel adding time problem

Hi

I have a column of date times increasing by 50 minutes every new row. I need it to continue this over a period of a few days, and to add 6 hours at midnight every day ie

A B C

  12 Jan 2019 22:00 0

50min 12 Jan 2019 22:50 0

50min 12 Jan 2019 23:40 0

50 min 13 Jan 21019 06:30 6 HRS

I am using a formula in column c asking to show 0 and if the date in column b changes show 0,25

I am then trying to add column A + column B value (cell above) + column c. I keep getting circular reference problems. Can someone please help me

 

By: Mark Jeffery

Leave a Reply

Your email address will not be published. Required fields are marked *