G
Guest
I have a what I hope is an easy problem to fix:
Text box 1: named Start_Time formatted as a Number
Text box 2: named End_Time formatted as a Number
Text box 3: named Hours formatted as a Number
Formula for calculating the time difference works great, but in Text box 3 I
need to get the value to show as decimal (or whatever it takes)
Example:
User will enter time as 24hr format (800 to 1530)
Start time is 800
End time is 1530
I need to get the Hours text box to show 7.5 hours. Right now it shows 730.0
Thank you,
Text box 1: named Start_Time formatted as a Number
Text box 2: named End_Time formatted as a Number
Text box 3: named Hours formatted as a Number
Formula for calculating the time difference works great, but in Text box 3 I
need to get the value to show as decimal (or whatever it takes)
Example:
User will enter time as 24hr format (800 to 1530)
Start time is 800
End time is 1530
I need to get the Hours text box to show 7.5 hours. Right now it shows 730.0
Thank you,