Timesheet calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top