M
MB
The data I have is imported into Excel as:
A1 A2
LOG_OFF 10/13/2009 09:50:45 AM
LOG_ON 10/13/2009 10:00:18 AM
CO_Incoming 10/13/2009 10:34:15 AM
CO_Incoming 10/13/2009 10:15:39 AM
LOG_OFF 10/13/2009 10:15:54 AM
LOG_ON 10/13/2009 10:27:13 AM
WRAP_ON 10/13/2009 10:34:45 AM
WRAP_OFF 10/13/2009 10:34:47 AM
Date and time are in the same cell (A2). How do I calculate total time off
between each LOG_OFF and LOG_ON? I used =INT(D8-D7)&"d
"&TEXT(MOD((D8-D7),1),"h:mm:ss"), but it doesn't apply to each row (I'm
guessing I need an IIF formula?). Also, the result is "Od 0:00:04" (for
example). I'll need the result to not include the "Od."
I'm using Excel 2007.
Thank you so much.
A1 A2
LOG_OFF 10/13/2009 09:50:45 AM
LOG_ON 10/13/2009 10:00:18 AM
CO_Incoming 10/13/2009 10:34:15 AM
CO_Incoming 10/13/2009 10:15:39 AM
LOG_OFF 10/13/2009 10:15:54 AM
LOG_ON 10/13/2009 10:27:13 AM
WRAP_ON 10/13/2009 10:34:45 AM
WRAP_OFF 10/13/2009 10:34:47 AM
Date and time are in the same cell (A2). How do I calculate total time off
between each LOG_OFF and LOG_ON? I used =INT(D8-D7)&"d
"&TEXT(MOD((D8-D7),1),"h:mm:ss"), but it doesn't apply to each row (I'm
guessing I need an IIF formula?). Also, the result is "Od 0:00:04" (for
example). I'll need the result to not include the "Od."
I'm using Excel 2007.
Thank you so much.