I want to enter a time in c2 and I want d2 to show a time 50 minutes earlier.
What formula can I use. These time formulas have me baffled.
Note when I format the cell for time and enter 0700 the time returns as 00:00.