Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mental block - number to hours...

Status
Not open for further replies.

robmason10

Technical User
Apr 9, 2002
68
GB
Have a field that is simply {?days}*7 (7 being working hours in a day)

I need to display the result as hours so that if {?days}=7 the the result returned is 49:00

 
Is {?days} always a whole number? if so :

totext({?days}*7,0,"")&":00"

Reebo
Scotland (Sunny with a Smile)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top