I have a spreadsheet where I am tracking time spent on sleep (11 week old baby, yay!), but some of the sleep sessions roll into a new day. For example, one goes from 9:00pm on January 10th to 3:25am on January 11th. Through the day it's no problem to track the hours spent sleeping but I get an error when the formula crosses a date line. Can anyone help me?
Bookmarks