List:General Discussion« Previous MessageNext Message »
From:Gyurasits Zoltán Date:July 27 2005 4:11pm
Subject:Hour counts
View as plain text  
Hello All!


I would like to calculate the hour counts from 2 'datetime'.
Example:   2005-07-27 18:00 and 2005-07-27 19:30  => 1,5 hour

I try this....  but not good!

R1 : munkaido_end-munkaido_start  /simple substract/
R2 : ROUND(ROUND((end-start)/10000)+
(((end-start)/1000-(ROUND((end-start)/10000)*10))/6),1)  /good if is in one day/
R3 : ROUND((end-start)/10000)-76  /-76 because from 14. to 15. I don't understand/


start               end                  R1                R2          R3
07-14 15:00     07-14 17:30     23000           2.5         -74
07-14 23:00     07-15 01:30     783000         78.5         2
07-14 15:00     07-15 02:30     873000         87.5         11
07-14 15:00     07-14 16:00     10000           1             -75

Please help me...    (exist a function for this situation?)


Tnx!

Thread
Hour countsGyurasits Zoltán27 Jul
  • Re: Hour countsMartijn Tonies27 Jul
  • Re: Hour countsJason Pyeron27 Jul
  • Re: Hour countsmfatene27 Jul
    • Re: Hour countsmfatene27 Jul
  • Re: Hour countsGyurasits Zoltán27 Jul
    • Re: Hour countsSGreen27 Jul
      • Re: Hour countsGyurasits Zoltán27 Jul
      • Re: Hour countsEric Bergen27 Jul
        • Re: Hour counts2wsxdr528 Jul
RE: Hour countsTerry Spencer27 Jul