Calculation hours from a Start-Date and End-Date

Follow

Eric Eckert

• July 23, 2014 14:48

Hello everybody,

I need a "simple" calculation wich creates a number (hours) out of a period of time (Start-Date and End-Date).
In the end I want podio to calculate my tarif for the day.
Would be nice if somebody could help.

Eric Eckert
ee

0

• 

  Ellen Boeke

  • July 30, 2014 17:23

  Hi Eric,

  This should do it for you:

  Math.abs((Start-Date.getTime() - End-Date.getTime())/3600000)

  Ellen

  0

  Comment actions Permalink
• 

  Paul Lyet

  • January 23, 2015 01:27

  Ellen.. Can you please explain this further. How do you define the equation? Cant seen to figure out how to reference the time field.

  0

  Comment actions Permalink
• 

  tuck

  • March 09, 2015 03:54

  Yes, this answer doesn't seem to work for me at all.
  I'm using the Calculation field. I have a Start Date and then an End Date field. However subtracting one from the other does nothing useful.

  0

  Comment actions Permalink
• 

  ESDC

  • March 19, 2015 09:48

  var d1 = moment(@Start Time);
  var d2 = moment(@End Time);
  var result = d2.diff(d1, 'hours');

  0

  Comment actions Permalink

Please sign in to leave a comment.