Time Calculations - hh:mm:ss conversion to hh


I am making an app that tracks time sheet entries. The user logs and “in” and “out” time with the date and time field picker, this is done daily. I want to calculate the hours logged by subtracting the “out” from the “in”, this gives me the time worked in format: hh:mm:ss.

How do I convert this to simple hh format?

Thanks for the help!


Date math will give you a duration in days/hour/minute I believe. Are you saying that you only want hours?

Have you tried the Date Difference column to see if that works for you?

Otherwise we might need to do some creative math in a math column to just return hours, which should be reasonably doable.