On 19 Jul 2011 at 12:26, Rich Shepard wrote: Date sent: Tue, 19 Jul 2011 12:26:12 -0700 (PDT) From: Rich Shepard <[email protected]> To: [email protected] Subject: Re: [libreoffice-users] Re: New User: Three Questions Send reply to: [email protected]
> On Tue, 19 Jul 2011, Andreas Säger wrote: > > > =X1*24 returns the time number in cell X1 in unit "Hours". > > =X1*24*Y1 multiplies the hours with an hourly wage in Y1. > > Andreas, > > It's not working for me here. Cell D3 contains '01:00:00 PM' and cell E3 > contains '07:00:00 PM'. In cell F3 I have '=(E3*24)-(D3*24)' and the display > is 0.00. If cell F3 contains '=E3-D3' then F3 shows '06:00'. The display for > 1-1/4 hours is '01:15' rather than 1.25. As soon as I put parentheses around > the cells the resulting display is '0.00'. Strange. > =(E3-D3)/TIME(1,0,0) The above formula seems to work for my test? 01:00:00 PM 07:00:00 PM 6 01:00:00 PM 04:15:00 PM 3.25 Note that with dates have two parts. The part to the left of the decimal is the day, and the right is the time. If both dates are the same day, there isn't a problem. One can always use the mod function to get rid of the day portion if. =(mod(e3,1)-mod(d3,1)) /time(1,0,0) The division by time(1,0,0) converts the hours into a numeric value. > Rich > > > -- > Unsubscribe instructions: E-mail to [email protected] > In case of problems unsubscribing, write to [email protected] > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be deleted > +----------------------------------------------------------+ Michael D. Setzer II - Computer Science Instructor Guam Community College Computer Center mailto:[email protected] mailto:[email protected] http://www.guam.net/home/mikes Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +----------------------------------------------------------+ http://setiathome.berkeley.edu (Original) Number of Seti Units Returned: 19,471 Processing time: 32 years, 290 days, 12 hours, 58 minutes (Total Hours: 287,489) BOINC@HOME CREDITS SETI 11017781.674213 | EINSTEIN 6206744.040851 ROSETTA 3394905.930636 | ABC 6973903.814446 -- Unsubscribe instructions: E-mail to [email protected] In case of problems unsubscribing, write to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
