Skip navigation

can someone help me with a simple duration calculation?

281 Views 3 Replies Latest reply: Apr 1, 2013 9:52 PM by Yellowbox RSS
NorthrailDrive Calculating status...
Currently Being Moderated
Mar 20, 2013 7:25 PM

I created a simple workbook for calculating hours worked. I am entering the start time, end time, and using the DUR2HOURS formula to calculate the duration. For some reason the calculation is wrong. I am sure it is somethign simple, but I could not find an answer and it has been bothering me for a couple of days now. Here is an example of what is happening:

 

Start Time     |     End Time     |     Duration

7:15 AM               5:30 PM               10.25  (formula: =DUR2HOURS(ENDTIME - STARTTIME)

 

The duration in this example should be 10.15?

 

Thanks,

 

Nate

MacBook, Mac OS X (10.4.8)

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.