▲ 3 r/excel
Trying to get a time value from two times, but some values are from different days, and I can't easily add dates
So essentially, I'm trying to sort through data for overtime. The data I'm given has the time started, and the time ended. Those times do not have dates attached. A simple subtraction works for 75% no problem. However, if the shift crosses into the next day, then the formula breaks down and I have no idea how to make the formula understand that we've ticked over to the next day
Excel version 2604
u/DurinsBane87 — 6 days ago