Hi there, I am trying to find the duration in total minutes between a start and stop time, both of which are in hh:mm military time format. The tricky part is, the end time could be the next day, and so end time could be less than start time. There are no columns defining date, just 2 columns with time of day in them (and of course other fields, but not pertinent to this).
Assuming start time is in column A and end time is in column B, I am doing an if statement for =if(B2>A2,minute(b2-a2),[something]). I know I need the "[something]" to be like b2+24hours-a2 but not sure how the syntax works for that. Thanks if you can help!
Assuming start time is in column A and end time is in column B, I am doing an if statement for =if(B2>A2,minute(b2-a2),[something]). I know I need the "[something]" to be like b2+24hours-a2 but not sure how the syntax works for that. Thanks if you can help!