Thread replies: 3
Thread images: 2
Thread images: 2
Anonymous
How to calculate total time of work from this text? 2016-07-26 12:41:45 Post No. 162121
[Report] Image search: [Google]
How to calculate total time of work from this text? 2016-07-26 12:41:45 Post No. 162121
[Report] Image search: [Google]
File: Work-time-634x325.jpg (54KB, 634x325px) Image search:
[Google]
54KB, 634x325px
How to calculate total time of work from this text?
Anonymous
2016-07-26 12:41:45
Post No. 162121
[Report]
Hey /wsr/,
can anyone please help me to calculate the total time of work in minutes from this text?
http://pastebin.com/raw/9WVcGNj3
The value on the left is the start time, the value on the right is the end time.
Example:
17:38:03 17:45:17
17:46:09 17:48:07
Total work: 0:09:36
Thanks in advance!
>>
File: Capture.jpg (83KB, 452x703px) Image search:
[Google]
83KB, 452x703px
Using my extremely limited Excel/sheets knowledge I've managed to extract the time difference between the two inputs, but I can't find a way to add the time(s) and get the correct result. I'll see if I figure something out.
>>
Op here,
solved using OpenOffice and this:
https://help.libreoffice.org/Calc/Calculating_Time_Differences
LibreOffice have a bug, everytime you copy+paste the time, it won't calculate it because it puts a " ' " before the time that you have to delete manually.
Thread posts: 3
Thread images: 2
Thread images: 2