Forum Academy Marketplace Showcase Pricing Features

Date & Time calculations

I’m trying to do simple math using date & time, clearly I’m missing something as I can’t seem to show the difference between a start and end date as hours and minutes. ie. 5:30pm - 8:00am = 9:30.
Any tips and advise out there?

One way that I can right now is - convert both the times into minutes(extract the hours from date and multiply by 60 plus all the minutes) and subtract both the minutes. Then divide the result by 60 and you get the hours and the remaining ones are minutes.

image

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.