Hello!!! I am doing calculations for the time it takes when a machine is undergoing maintenance. Right now, I calculated the time in hours it takes for the maintenance, thus how long the machine was not in use, BUT I want the time to only show how much it was down for that specific day. My code will be based on the time column. If machine maintenance starts on one day (i.e., 9/7) but ends the next day (i.e., 9/8), I want one row to show the machine downtime for 9/7 =24 hours- time in hours when machine was being worked on AND a new row to be created for 9/8=24 hours- time down during that day CURRENTLY It gives me the time in hours in a row based on when the machine started to be working on ....current results
BUT I want....
Can I have help please!!!! Code: index=.......search..... | eval open = strptime(Open_Date, "%m/%d/%Y %I:%M:%S %P") | eval close = strptime(Close_Date, "%m/%d/%Y %I:%M:%S %P") |eval Diff=round(((close-open)/3600),1) |eval CloseTime=strftime(close,"%Y-%m-%d") |eval OpenTime=strftime(open,"%Y-%m-%d") |eval Time=strftime(_time,"%Y-%m-%d") |table Time OpenTime CloseTime Close_Date Open_Date Diff
... View more