Calculation based on value lists

[Tech_knowledge]

Hello,

hopefully someone can point me in the right direction with this one, I have two value list of times, start time and end time and I have another field that's a calculation field based off of my two time value list when I subtract end time from start time I get and whole number for instance 1, 2, 3 and I would like a more accurate calculation for instance

START TIME 4:00 AM

END TIME : 5:15 PM

RESULT : 13.15 HOURS USED

IS THIS POSSIBLE?

[Ender]

Set your Result field's format to display the decimal portion of the number (Result IS a number result, right?)

[Tech_knowledge]

No RESULT is a calculation field END TIME - START TIME, should I change it to a number field and have evaluate a calculation?

[comment]

If both END TIME and START TIME are Time fields, and your calculation field result is set to Time, then that should be it.

Check how the field is formatted to display Time (in Layout mode).

[Ender]

Oops, thought you were looking for the decimal remainder, but that's a different calc (13.25 hours, instead of 13:15 hours.)

[Tech_knowledge]

Sorry, I'm a little confused and it may be my fault, I have two value list with times, the user selects the time my RESULT field is simply a calculation field that subtracts END TIME from START TIME and the result that I want is a decimal remainder for instance 13.25 hours used

[Ender]

In that case the Result calc would be:

Result (calculation, number result) = (End Time - Start Time) / 3600

Where this field is displayed, it should be formatted to have 2 decimal places.

[Tech_knowledge]

I don't understand your equation

Result(calculation, number result) what's this I

don't see a function named result how exactly would

I implement this?

[Ender]

Result is not a function, it's the name of your calc. "calculation" is the field type and "number result" is the type of result the calculation produces. There's not a great way to describe field definitions, so we use this format.

[Tech_knowledge]

You're a modern day genius, thanks a million!!!!!!