=(A2-A1)*24

Format as General

HTH
Kostis Vezerides

On Jul 3, 6:27 pm, tnal wrote:
I have the start time in one column and the end time in another. Excel will
subtract the time in hours and minutes. This is great, but I want to show 2
hours and 30 minutes as 2.50, not 2.30. How can I make it show quarter
hours, half hours, and three quarters of an hour so I can add the column to
show total hours worked?
--
tna