Helen,

Try this where C1 is the hours worked, drag down as required:-

=(C1-INT(C1))*24

Mike

"Helen" wrote:

In a timesheet, I'd like to be able to do a calculation for the hours worked,
then convert it to decimal.

Column A - Start Time
Column B - End Time
Column C - Hours Worked

Col A = 08:30
Col B = 15:00
Col C = 6:30 = 6.5


Is there such a formula?