Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Time Past Midnight
I have 4 columns in a worksheet. Column 1 has the date, 2 has the time, 3
has the end date and column 4 has the end time. How can I calculate time when the time passes the midnight in column 5? There are more than 12,000 rows and it takes forever to manually make the changes. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Difference Between Start Date & Time And End Date & Ti | Excel Discussion (Misc queries) | |||
Calculating a time sheet? | Excel Worksheet Functions | |||
I need help with a formula calculating time | Excel Discussion (Misc queries) | |||
unmet challenge | Excel Worksheet Functions | |||
calculating with a time format cell | Excel Worksheet Functions |