I am trying to figure out how to calculate times in Excel. I was using the text function to do this, then I realized we could not do caluclations on text fields.
So, now I am using the =(b1-a1)*1440 to caluclate the minutes to get time differences. I have found that to be the best way so far, but we come into issues when we are doing multiple days of time. Is there an easier way to do time differentials that can be calculated?
If this confused you, please read the attachment while might make life easier. :redface: