| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Time
I have Excel 2003
I have a spreadsheet (I didn't create this spreadsheet and it has much info filled in) that has a column showing the start date, next column shows the start time in military time, ,next column shows the end date, next column shows the end time in military time. I need a column to show how many hours/mins that equals. IE if column G row 3 = 5/28/2008; Column H row 3 = 1000; Column I row 3 = 5/29/2008; Column J row 3 = 900; that would be an elapsed time of 23 hours. How can I make a formula to make it figure that elapsed time ? Thanks, Meenie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Regular time, overtime and double time | Excel Worksheet Functions | |||
| Calculating time and negative time | Excel Worksheet Functions | |||
| calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
| Calculating effective time from start/end date+time | Excel Worksheet Functions | |||
Threaded Mode
