freecolours Posted September 23, 2002 Posted September 23, 2002 I'dd like to have a numberfield that shows a timecalculation in numbers from a timefield. Example: 'total working hours: 3:15', and then have '3,25' in a numberfield.
LiveOak Posted September 23, 2002 Posted September 23, 2002 Hour(MyTime) + Round( Minute(MyTime)/60, 2) -bd
Kurt Knippel Posted September 23, 2002 Posted September 23, 2002 Or: Hour(MyTime) & "," & Round( Minute(MyTime)/60, 2) To get the comma into the formatting.
freecolours Posted September 23, 2002 Author Posted September 23, 2002 Yes, it works!! Thanks alot LiveOak and CaptKurt!
Recommended Posts
This topic is 8167 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now