View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default Hours and minutes

You can use the SUM function to get total minutes then. Let's say your
values are in A1 through A50, then use this...

=SUM(A1:A50)

--
Rick (MVP - Excel)


"Eán" wrote in message
...
currently the numbers are entered as numbers. i.e. 15+30+90 etc.

"Joel" wrote:

It depends how your numbers are entered. Is 15mins a number or a text
string? I have a UDF that can add strings I can modify it to return a
time.

"Eán" wrote:

If I want to record time spent is there a function I can use to add
time,
that is for example:

15mins + 30mins + 90mins = 2hrs 15mins or 135mins.

Please and thank you