time function

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

Guest

I am new to spreadsheets and need to show the elapsed time between finishing
and starting working periods, in hours and minutes, when these periods often
exceed 24 hours
 
Hi,

If the period can exceed 24 hours then you need a date as well as a time for
start and finish so in your start time cell (Say A1) enter:-

1/1/2007 06:00

In your end time cell (Say B1) enter

2/1/2007 22:00

now simply do a subtraction = B1-A1
Note that B1 is the later time. Format the cell as [hh]:mm and your done.

Mike
 

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