Add number formats for just hours for calculating time elapsed
When calculating time elapsed, I would like a format option for the answer to show up in just hours instead of hours and minutes. Right now, 7:00 am to 3:30 pm will result in a time elapsed of 8:30. (hours and minutes) I would like an option for it to show up as 8.5 (hours only). This will help in calculating payroll.
Kenneth Barber commented
I agree with JoeU. Also, believe it or not, times like 8:30 are actually stored with the unit assumed to be days. If you want to make it clearer that you are doing a unit conversion, you can go =CONVERT(B1-A1,"day","hr").
Must it be a format option per se? Are you aware that if A1 is 7:00 AM and B1 is 3:30 PM, then =(B1-A1)*24 is 8.5?
Note that format options only affect the appearance, not the actual value. So a format option per se that displays 8.5 for =(B1-A1) would not change the fact that the actual value is 8:30. Consequently, if the formatted formula is in C1, =C1*15 would __not__ result in $127.50, the pay for 8.5 hours at $15 per hour.