Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Summing Hours and Minutes
Hello,
I have a TIME ...I then subtract from it another TIME. The first is formatted like 4:30 PM the second is formatted like 10/5 5:00 PM. I then get the answer and I format it using hh:mm so my answer may be 5:44 ...meaning 5 hours 44 minutes.... I try to take all the answers and get a sum and I get ##### I make the column wider...but its never wide enough so I suppose something is wrong with my premise here. Any help is greatly appreciated. Ken |
#2
|
|||
|
|||
Hi,
Try the following formula in another cell, =INT(B10*24)&" : "&IF(LEN(ROUND(MOD(B10*24,1)*60,2))=1,"0"&ROUND(MO D(B10*24,1)*60,2),ROUND(MOD(B10*24,1)*60,2)) Change the 'B10's in the formula (there are four) to the cell address showing the ###### in your spreadsheet. Regards, B. R. Ramachandran "KenRamoska" wrote: Hello, I have a TIME ...I then subtract from it another TIME. The first is formatted like 4:30 PM the second is formatted like 10/5 5:00 PM. I then get the answer and I format it using hh:mm so my answer may be 5:44 ...meaning 5 hours 44 minutes.... I try to take all the answers and get a sum and I get ##### I make the column wider...but its never wide enough so I suppose something is wrong with my premise here. Any help is greatly appreciated. Ken |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding hours and minutes | Excel Worksheet Functions | |||
Adding minutes showing total in hours/minutes, i.e., 60 mins + 60 mins + 15 mins to total of 2 hours 15 mins? | Excel Discussion (Misc queries) | |||
Help for a newbie trying to add hours and minutes :) | Excel Discussion (Misc queries) | |||
How do I add/subtract hours and minutes when some values exceed 2. | Excel Discussion (Misc queries) | |||
convert hours and minutes to minutes | Excel Discussion (Misc queries) |