Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Howdy!
I am working on a project where I have a start time in [h]:mm:ss and duration of time in seconds. I would like to add the seconds to the time and come up with a time formatted result Here is an example: Cell B1 has a Start time of 3:59:50 PM (format [h]:mm:ss) Cell B2 has a Duration of 21 seconds. (Some of the durations can be more than 3600 seconds) Cell B3 would be the Result: End time should be 4:00:11 PM I have the cell formatting set to general for the seconds. I don't know the correct time format for those cells. I have searched the web and cant seem to find it anywhere. I see adding time etc but not what I'm trying to do. Thanks in advance for any help! -Joe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding time HH:MM when it addds up to more than 24 hours | New Users to Excel | |||
Adding time | Excel Worksheet Functions | |||
NOW Function For Time Changes With Each New Macro | Excel Worksheet Functions | |||
Adding Time | Excel Worksheet Functions | |||
Date & Time | New Users to Excel |