Originally Posted by
June7
...Just save the value as 90 in a number field and calculate it to hrs/mins in query or textbox. Leaving the value as minutes in table will allow greater versatility (sum, average, minimum, maximum, etc)...
I agree with June7 on this. Where TotalMinutes is the original Field or Textbox and FormattedTime is the Calculated Field, the general expression would be
As the Control Source of an Unbound Textbox
= ([TotalMinutes] \ 60) & "hrs" & " " & ([TotalMinutes] Mod 60) & "mins"
As a Calculated Field in a Query
FormattedTime: ([TotalMinutes] \ 60) & "hrs" & " " & ([TotalMinutes] Mod 60) & "mins"
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007