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?

2 Answers 2


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. :) Commented Apr 26, 2016 at 15:32
  • 1
    @Christoffer Great minds answer alike!
    – Thriggle
    Commented Apr 26, 2016 at 15:33

Change your calculation to


and set the column type to Number with 1 decimal.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.