I have a list of date and time stamps where I'm calculating the difference. All was well until some dates a missing. So time stamp of 8/1/2019 1:10 PM, then the next time stamp is 8/3/2019 6:30 am. The person obviously took a day off and in some instances takes 1-2 weeks off. We need to find 24 hour intervals so I'd like to find the time from 8/1/2019 1:10 PM to 8/2/2019 00:00:00. Or whatever midnight of 8/1/2019 is to Excel. Been Googling for hours and everything is end time minus start time, but having difficult figuring out how to use midnight as the end time.
Thanks much,
tarork
Bookmarks