| View previous topic :: View next topic |
| Author |
Message |
BigO
Newbie
Joined: 27 Apr 2006
Posts: 2
|
 Posted: Thu Apr 27, 2006 4:31 am Post subject: Calaculating total time |
 |
|
I am creating a spreadsheet to keep track of my hours worked at my job.
I am having trouble remembering what formula to use when you calaculate time.
This is what I am trying to do:
Add 8am-11am to give me 3 hours...but when I use the sum command, it comes uup with 7pm...what am I doing wrong? |
|
| Back to top |
|
 |
bomb #21
General User
Joined: 23 Apr 2006
Posts: 23
|
| Posted: Thu Apr 27, 2006 5:30 am Post subject: |
|
|
Instead of:
=StartTime+EndTime
use:
=EndTime-StartTime (minus).
_________________
In the beginning there was darkness. And the darkness was without form and void. And in addition to the darkness there was also me. And I moved upon the face of the darkness and I saw that I was alone. |
|
| Back to top |
|
|
BigO
Newbie
Joined: 27 Apr 2006
Posts: 2
|
| Posted: Thu Apr 27, 2006 5:54 am Post subject: |
|
|
| Thanks, worked like a charm. |
|
| Back to top |
|
|
|
