{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Working Hour"],"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":"Working Hour","index":0,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[2,1,2,2],[2,4,2,5]]}
[]
[null,"Hour and Minute Calculation"]
[null,"Employee Name : Ross Jonshon",null,null,"Month: December (Partial)"]
[null,"Per Hour Pay",15]
[]
[null,"Date","Entering Time","Exiting Time","Time Worked (h:mm)","Total Pay"]
[null,"2021-12-01","08:20:00","17:15:00",{"$f":"TEXT(D7-C7,\"h:mm\")","v":"8:55"},{"$f":"$C$4*E7*24","v":133.75}]
[null,"2021-12-02","08:00:00","17:25:00",{"$f":"TEXT(D8-C8,\"h:mm\")","v":"9:25"},{"$f":"$C$4*E8*24","v":141.25}]
[null,"2021-12-05","08:15:00","18:30:00","10:15",153.75]
[null,"2021-12-06","10:00:00","19:15:00","9:15",138.75]
[null,"2021-12-05","09:10:00","17:00:00","7:50",117.5]
[null,"2021-12-06","09:15:00","17:30:00","8:15",123.75]
[null,"2021-12-07","09:20:00","18:10:00","8:50",132.5]
[null,"2021-12-08","09:30:00","17:45:00","8:15",123.75]
[null,"2021-12-09","10:00:00","17:20:00","7:20",110]
[null,"2021-12-12","08:20:00","18:10:00","9:50",147.5]