Timesheet calculation

R

RichardBurrow

I am trying with little sucess to produce an spreadsheet in which I can
calculate total times it takes me when working on a job. i.e-

START TIME: 8:30am
FINISH TIME: 9:30am
Total time: 1hour
 
F

Frank Kabel

Hi
just use
=A2-A1
and format the result as time

or if you need a decimal value use:
=(A2-A1)*24
and format as number
 
Top