Hi Team, I have a Job Start Date field & Job End Date field I want the Elapsed Time so I take the calculation as Datefdiff(Job Start Date, Job End Date, ‘HH’) as per formula we put only HH or MM not both so how can I achieve the Elapsed Time as HH:MM

I would take the seconds difference and convert it to HH:MM afterwards. Datefdiff(Job Start Date, Job End Date, ‘SS’) Then run it through this conversion [image] Convert time duration to HH:MM:SS Articles Sharing a calculated field you can use to convert a numeric field…

How Can I used the Datediff function for HH:MM Calculation I need two date field duration as HH:MM

Question & Answer

Max February 24, 2023, 6:43pm 2

I would take the seconds difference and convert it to HH:MM afterwards.

Datefdiff(Job Start Date, Job End Date, ‘SS’)

Then run it through this conversion