Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add a duration time value and a clock time value?
I have a column containing cells formatted with the "1:30 PM" option (clock
time), and a column containing cells formatted with the "37:30:55" option (duration time). I know I can jump through several hoops to extract and add the various segments to get a new clock time, but I can't believe it's that difficult. This MUST be a relatively common need, and surely I'm making it more convoluted than it is, but I can't find the elegant way. |