1

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?

3

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
  • 1
    @Christoffer Great minds answer alike! – Thriggle Apr 26 '16 at 15:33
2

Change your calculation to

=24*(start-end)

and set the column type to Number with 1 decimal.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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