Days, Hours & Minutes 1

[RAClarke]

If I wish to sum up a column of hours on a form, how can I format a text box to show the result in days, hours and minutes (if in fact I can)?

Thanks

 

[Trendsetter]

AS a guess I would think -
in the format section of the properties page hh:nn:ss

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk

 

[AlanKW]

Are the hours stored in date/time format or decimal?

 

[Trendsetter]

as part of the Date/Time format

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk

 

[RAClarke]

The hours are stored in date/time format.

 

[PHV]

Something like this ?
SELECT Int(Sum(theTable.Time)) & " day " & Format(Sum(theTable.Time),'hh:nn') AS TotalTime
FROM theTable

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244