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?