| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Time Past Midnight
What is the format of the two times?
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Darren" wrote in message ... 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 | |||
Threaded Mode
