Calculations with time values

  • Thread starter Thread starter Luis
  • Start date Start date
L

Luis

how can calculate a time values with out getting an error
ie; 8:00+8:00+8:00=0 (time values)
the result should be 24 hrs not cero (0)
Thank you
 
Date/times are stored as "special" real numbers, with the whole number
part corresponding to the number of days since December 31, 1899 (from
memory) and the fractional part corresponding to the time past
midnight in fractions of a _day_. They are not really intended for use
to store elapsed times, especially when these go over 24 hours.

The result of your calculation is 1 day, which will be stored
correctly in the date/time variable which you are using to hold it..
If you display the contents of this variable using a time format,
however, only the fractional part of the date/time is displayed, which
is zero in this case. If a time difference is going to exceed 24
hours, you really need to cast it into a regular real variable and
convert and format it manually.
 

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