Submitted by jan_rifkinson on 2011/04/20 12:47
This formula has worked up until now.
See file attachment

Comments

Looks ok to me :  2 hours and 0.67 hour.  ;)
Jokes apart, I don't remember that the worktime function chnaged, but maybe it did.
 
- The "DateTimeTotal" (Hrs) field should be set to "date" to show hours and minutes. Otherwise it's just a number field... But you can't change the type now, so that's a useless point.
- I believe the WorkTime function would need to convert decimals into minutes, which isn't the case. 
- Maybe is there a way to set the "option" section in the DateTimeTotal to show hours and minutes... Maybe Pierre will have a idea... I don't know much about the syntax there.
 
 
--------------------------------------------------------------------------------
Windows XP Home Edition, Service pack 2
Dell Vostro 1500, Ram:3gb, CPU:Core2Duo T7500 2.2ghz

jan_rifkinson

2011/04/20 15:52

Permalink

Attached is an example of it's working the way I wanted it to. Maybe it's just a fluke.???

Armando

2011/04/20 16:01

Permalink

Is it that you'd like minutes to be rounded ? (e.g. : 2.67 --> 2.5 or 3)
I'm not sure I understand.
--------------------------------------------------------------------------------
Windows XP Home Edition, Service pack 2
Dell Vostro 1500, Ram:3gb, CPU:Core2Duo T7500 2.2ghz