Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
Whey is Excel 2003 calculating take so long - sometimes 20 minute | Excel Worksheet Functions | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Convert seconds to minutes and seconds in excel | Excel Worksheet Functions |