{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sheet1","Sheet4","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use Formula to Calculate Time Difference in Minutes"]
[]
[null,"Start Time","End Time","Time Difference\n(Minutes)"]
[null,"2021-01-10T10:30:00","2022-04-19T10:53:00",{"$f":"(C5-B5)*1440","v":668183.00000000163}]
[null,"2021-03-11T13:34:00","2022-04-20T10:53:00",{"$f":"(C6-B6)*1440","v":583038.99999999907}]
[null,"2021-03-12T14:34:00","2022-04-21T10:53:00",582979.00000000256]
[null,"2021-01-11T10:30:00","2022-04-22T10:53:00",671063.00000000163]
[null,"2021-02-12T10:30:00","2022-04-23T10:53:00",626423.00000000163]
[null,"2021-04-14T11:35:00","2022-04-24T10:53:00",539957.9999999993]
[null,"2021-03-15T15:45:00","2022-04-25T10:53:00",584348.00000000163]
[null,"2021-03-16T18:46:00","2022-04-26T10:53:00",584166.99999999837]

{"sheet":"Sheet4","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sample Data Set to Calculate Time Difference in Minutes"]
[]
[null,"Start Time","End Time","Time Difference\n(Minutes)"]
[null,"2021-01-10T10:30:00","2022-04-19T10:53:00"]
[null,"2021-03-11T13:34:00","2022-04-20T10:53:00",{"$f":"(C6-B6)*24*60","v":583038.99999999907}]
[null,"2021-03-12T14:34:00","2022-04-21T10:53:00",582979.00000000256]
[null,"2021-01-11T10:30:00","2022-04-22T10:53:00",671063.00000000163]
[null,"2021-02-12T10:30:00","2022-04-23T10:53:00",626423.00000000163]
[null,"2021-04-14T11:35:00","2022-04-24T10:53:00",539957.9999999993]
[null,"2021-03-15T15:45:00","2022-04-25T10:53:00",584348.00000000163]
[null,"2021-03-16T18:46:00","2022-04-26T10:53:00",584166.99999999837]

{"sheet":"Sheet2","index":2,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Apply DAYS, HOUR, and SECOND Functions to Calculate Time Difference"]
[]
[null,"Start Time","End Time","Days","Minutes","Seconds","Time Difference\n(Minutes)"]
[null,"2021-01-10T10:30:00","2022-04-19T10:53:36",{"$f":"_xlfn.DAYS(C5,B5)","v":464},{"$f":"MINUTE(C5-B5)","v":23},{"$f":"SECOND(C5-B5)","v":36},{"$f":"D5*24*60 + E5 + F5/60","v":668183.6},null,null,null,null,null,null,null,"*=D5*24*60 + E5 + F5/60"]
[null,"2021-03-11T13:34:00","2022-04-20T10:53:00",{"$f":"_xlfn.DAYS(C6,B6)","v":405},{"$f":"MINUTE(C6-B6)","v":19},{"$f":"SECOND(C6-B6)","v":0},{"$f":"D6*24*60 + E6 + F6/60-1440+H6*60","v":583039},{"$f":"HOUR(C6-B6)","v":21}]
[null,"2021-03-12T14:34:00","2022-04-21T10:53:00",405,19,0,{"$f":"D7*24*60 + E7 + F7/60","v":583219}]
[null,"2021-01-11T10:30:00","2022-04-22T10:53:37",466,23,37,671063.6166666667]
[null,"2021-02-12T10:30:00","2022-04-23T10:53:43",435,23,43,626423.71666666667]
[null,"2021-04-14T11:35:00","2022-04-24T10:53:24",375,18,24,540018.4]
[null,"2021-03-15T15:45:00","2022-04-25T10:53:00",406,8,0,584648]
[null,"2021-03-16T18:46:00","2022-04-26T10:53:00",406,7,0,584647]

{"sheet":"Sheet3","index":3,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Run a VBA Code to Calculate Time Difference"]
[]
[null,"Start Time","End Time",null,"Time Difference\n(Minutes)"]
[null,"2021-01-10T10:30:00","2022-04-19T10:53:00",null,584478.99999999907]
[null,"2021-03-11T13:34:00","2022-04-20T10:53:00"]
[null,"2021-03-12T14:34:00","2022-04-21T10:53:00"]
[null,"2021-01-11T10:30:00","2022-04-22T10:53:00"]
[null,"2021-02-12T10:30:00","2022-04-23T10:53:00"]
[null,"2021-04-14T11:35:00","2022-04-24T10:53:00"]
[null,"2021-03-15T15:45:00","2022-04-25T10:53:00"]
[null,"2021-03-16T18:46:00","2022-04-26T10:53:00"]