Timestamps will allow for midnight automatically.
TimestampEnd - TimeStampStart
computes the elapsed time in seconds. You can select time as a result type or use:
( TimestampEnd - TimeStampStart ) / 3600
with a number result type to get the elapsed time in hours.
Now a'm using use the timestamp my values list does not work anymore.
Do you have an solution to get a dropdownlist ￼counting by Quarters?
Please explain how you need your value list to work. What values are you selecting from it? How does the value list affect this calculation?
I want the fields to use to calculate spent time. The timesstamp set te time in minutes but I want to finish by quarters by invoice.
12.00 unto 13.15 (and not 13,14) that way I always keep a nice calculation resulting from the input.
12.00 unto 13.15 = 1,25
12.00 unto 13.14 = 1,2333333333333333
To avoid this,i want the list of options of import thus affect per quarters
Do you mean that you want to round elapsed time to the nearest 15 minutes? This is a common way to compute elapsed time on employee time cards and easy to include as part of the calculation to compute elapsed time.
But what does that have to do with your "values list"?
Thanks for the solution, is this solution count automatically? Because that's not what I'm looking for.The reason I told the value list what's the best solution for me is the vision that I want to use a field with a drop-down list with blocks from 15 minutes .Start Date Stop Date Calculation hours(dropdown) (dropdown)
00:00 V 20-11-2013 00:00 V 20-11-2013 timestamp Stop - timestamp Start = 0.25 Hour(s)00:15 00:1500:30 00:3000:45 ......01:0001.15.....
You can use a time field for the time and a date field for the date. Then your calculation can be modified to be this to compute the elapsed hours:
( TimeStamp ( StopDate ; StopTime ) - TimeStamp ( StartDate ; StartTime ) ) / 3600