Format a field for Time, but as duration?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,

I have a field in a table where users enter the time a task took. This is
entered in minutes, such as 90 minutes (1hr 30mins)

The field is currently a Number field which works but I can see that will
cause problems when we come to analyse the data and need to total the hours
and minutes.

What is the best way to format the field in the tabel so that the data will
actually be held in hours and minutes (but not time of day) and can therefore
be used to summarise without adding calculations to it?
.

Relevant Pages

  • Re: Problems with multiplications of doubles and/or floats
    ... lot of calculations in it, they all work fine except the one mentioned ... //Get position of first node ... ElleNodePrevPosition(index, & prev); ...
    (comp.lang.cpp)
  • Re: (N+1)^N/N^N
    ... >and yet it seems to be FOUNDATIONAL in many calculations. ... David C. Ullrich ... Prev by Date: ...
    (sci.math)
  • Re: Totals Queries
    ... or you can uncheck the Show checkbox on the rate if ... you only need to use it in calculations. ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: Varying a Latitude/Longitude
    ... longitude. ... I'll bet one of them can do these calculations, ... jumped out at me when I very quickly skimmed over the one-liner ... Prev by Date: ...
    (comp.lang.perl.misc)
  • add two matrix
    ... or in another exemple: ... but this way of making the calculations, with For loops is very slow, ... Prev by Date: ...
    (comp.soft-sys.matlab)