Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time again
it seems that working with time is more complicated than one would think. i
would like to add a column of hours and minutes, to come up with a total of hours and minutes. b1 would be 1.50... 1 hr and 50 minutes b2 - 4.45 b3 - 7.35 etc. which should be 14 hours and 17 minutes. any help would be great appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time again
All about calculating with times:
http://www.cpearson.com/excel/datetime.htm#AddingTimes -- Kind regards, Niek Otten "Chas D" wrote in message ... it seems that working with time is more complicated than one would think. i would like to add a column of hours and minutes, to come up with a total of hours and minutes. b1 would be 1.50... 1 hr and 50 minutes b2 - 4.45 b3 - 7.35 etc. which should be 14 hours and 17 minutes. any help would be great appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entering Times | Excel Discussion (Misc queries) | |||
time differences in a column | Excel Worksheet Functions | |||
Accumulate weekly time to total time in Excel. | Excel Discussion (Misc queries) | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |