Time sheet - In / Out Times and hours calculation

Windows 7 64bit / MS Excel 2007

I need to create a simple weekly timesheet with the following data and calculation;

A 'time in' cell "A", a 'time out cell' "B" for each day of the week, and a calculation cell "C" for the hours worked each day.

I thought I was pretty smart till I tried to do this simple task, but . . . . I'm getting old :-) Your help is very much appreciated - IM

Hi and welcome to the board

Times entered as hh:mm

In C1 enter =(B1-A1)*24 gives time worked as a decimal number

Thanks Arthur, perfect :-)

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save