Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Times
I have a column (Time) which combines two other columns (Hours and Minutes). TIME -0.44 -0.27 0.49 -0.06 2.43 7.52 _-1.02_ 8.65 My results come back with a "." instead of a ":". These numbers are in this format "hh.mm". The numbers after the decimal (7.52 for example) are not fractions of hours, but actual minutes (7 hours and 52 minutes). I need to be able to add up these times and show them in the format "hh:mm". I dont want it to return 8.65, but 9:05 instead. I have trouble adding "negative" times. Can this be done in Excel? Is there any way to do this?!? TIA, DejaVu -- DejaVu ------------------------------------------------------------------------ DejaVu's Profile: http://www.excelforum.com/member.php...o&userid=22629 View this thread: http://www.excelforum.com/showthread...hreadid=399146 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Times
I have trouble adding "negative" times. Can this be done in Excel?
A formula can display negative time if you select the 1904 date system under Tools, Options, Calculation. -- Jim "DejaVu" wrote in message ... | | I have a column (Time) which combines two other columns (Hours and | Minutes). | TIME | -0.44 | -0.27 | 0.49 | -0.06 | 2.43 | 7.52 | _-1.02_ | 8.65 | | My results come back with a "." instead of a ":". These numbers are in | this format "hh.mm". The numbers after the decimal (7.52 for example) | are not fractions of hours, but actual minutes (7 hours and 52 | minutes). I need to be able to add up these times and show them in the | format "hh:mm". | I dont want it to return 8.65, but 9:05 instead. | I have trouble adding "negative" times. Can this be done in Excel? | | Is there any way to do this?!? | | TIA, | | DejaVu | | | -- | DejaVu | ------------------------------------------------------------------------ | DejaVu's Profile: http://www.excelforum.com/member.php...o&userid=22629 | View this thread: http://www.excelforum.com/showthread...hreadid=399146 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Times | Excel Discussion (Misc queries) | |||
adding times | Excel Discussion (Misc queries) | |||
adding times | Excel Discussion (Misc queries) | |||
Adding times | Excel Worksheet Functions | |||
Adding Times | Excel Worksheet Functions |