Simple Time calculation

Question

Hello AllI realise this has been asked many times, but I am truly struggling to find a simple script.I have three columnsA= Start Time (in 24hr time format)B = End Time (in 24 hour time format)C = Total Hours (in 24 hour time formathow do I subtract B from A to get a time in C (in 24hr time format)There are no dropdowns in any column, user enters data as time in A & BThere are also multiple rows, so I'd need each one to calculate seperatelyPlus do a total calculation at bottomI have included picture of what I am trying to achieve I am literally pulling my hair out, have tried just about every variation I have found on here &#128542;

try67 · Answer

This requires using a script. These tutorials explain the subject in quite detail:

https://acrobatusers.com/tutorials/working-with-date-and-time-in-acrobat-javascript

https://acrobatusers.com/tutorials/working-with-date-and-time-in-acrobat-javascript-part-2

https://acrobatusers.com/tutorials/working-date-and-time-acrobat-javascript-part-3-3

Alternatively, if you're interested, I've developed a (paid-for) tool that will allow you to set up all of these calculations quite easily, and without having to write any code. You can find it here:

https://www.try67.com/tool/acrobat-calculate-time-differences-in-a-worksheet

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded