View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gabe
 
Posts: n/a
Default Calculating Minutes in Excel

Hello,

I am trying to add minutes up in Excel, but I can't figure out which formula
to use to display the total correctly? I am trying to add 55 plus 55 as
integers(110), I need the total to be displayed as 1.50 (.50) being the
difference in minutes. Here is a better look.

A1 = 55, A2 = 55, A3 =SUM(A1:A2)/60, A3 displays the value (1.8333).

Is there anyway to display the value as 1.50, instead of (1.8333) and keep
the value an integer? Any help would be greatly appriciated. Thanks.