# Calculated field for difference between two times

I have a list with a "Start" field and "End" field. I'm using a calculated field to determine the difference in hours and minutes between the two. Start - 9:00 am End - 10:30 am =TEXT(End-Start,"h:mm")

The problem I have is that I don't want the time result to display as 2:30... but I can't figure out how to have the time display as 2.5 so that I can use that field to calculate the pay.

I tried using =INT but then it doesn't return the 30 minutes.

Is there another way to return the information in the format I want?

When you subtract a date field from another date field in a calculated column, the result is given in days.

You can therefore multiply the difference by 24 to get the result in hours, so your formula would likely look like this: `=24*(End-Start)`

Make sure to set your calculated column to return a number instead of text.

• Damn, beat me by the second. :) – Christoffer Apr 26 '16 at 15:32
• @Christoffer Great minds answer alike! – Thriggle Apr 26 '16 at 15:33

``````=24*(start-end)
and set the column type to `Number` with 1 decimal.