Results 1 to 2 of 2
I am trying to make a spreadsheet that calculates how long I've worked. The problem is, I work nights sometimes and need a calculator that will calculate start times from ...
- 10-15-2008 #1Linux Enthusiast
- Join Date
- Aug 2004
- Location
- Xanadu, Titan, Saturn
- Posts
- 610
Spreadsheets... for calculating hours worked...
I am trying to make a spreadsheet that calculates how long I've worked. The problem is, I work nights sometimes and need a calculator that will calculate start times from PM to AM. What I have now calculates it wrong. I took the formulas from another spreadsheet.
Here is what I have so far (only A4 and B4 calculate at the moment). It is a OpenOffice spreadsheet.
Does anyone know how to do this? Thanks!
- 10-16-2008 #2Linux Guru
- Join Date
- Apr 2005
- Location
- CA, but from N.Ireland
- Posts
- 2,413
A dumb solution might be to try using 24 hour times -- i.e. 21:00 not 9:00PM.
Registered Linux user #388328 || Registered LFS user #15880
AMD 64 X2 4600+ :: 2X1GB DDR2 800 :: GeForce 9400 GT 512MB :: ASUS M2N32 Deluxe :: 4X250GB SATAII
Need instant help? Try us on IRC -- #linuxforums on freenode
Reply With Quote 
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
