I have extracted data that shows when my dryers and iron were running. (See attached) I need a formula that subtracts the off time from the on time. I can do this manually but this is a months worth of data. Any help would be greatly appreciated.
I have extracted data that shows when my dryers and iron were running. (See attached) I need a formula that subtracts the off time from the on time. I can do this manually but this is a months worth of data. Any help would be greatly appreciated.
Try in I2:M4677and format for time.Formula:Please Login or Register to view this content.
Dave
Perfect!!! Thanks!!!
You are welcome. Glad to help. Thank you for the feedback and added rep.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Office Insider
I2 --> =IF(D2="Off",$C2-XLOOKUP("On",D$2:D2,$C$2:$C2,0,-1),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks