excel-Count minutes

  • Thread starter Thread starter Afonso Guimarães
  • Start date Start date
A

Afonso Guimarães

For control a telecom billing i need to convert Time in minutes (amount of
minutes, not minutes and houres).

I have a sheet with all the calls make during a month and i need to sum the
time of every call to obtain the total of minutes.

Anyone could help me ??

Thanks in advance

Afonso Guimaraes

Rio Tinto - Porto - Portugal
 
Just sum and assuming the format is mm:ss or hh:mm:ss
then multiply the total by 1440

=SUM(A1:A31)*1440

format result as general

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Back
Top