| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating the minutes between two times
Hello all,
A time card application: If I enter a start time in a cell and a ending time in another cell, how to I calculate the minutes in-between? For example, a cell contains 6:00 AM and another cell contains 2:30PM. I know that is 8 hours worked (with half hour lunch). How can I have Excel calculate 8.5 hours or 510 minutes? Thanks kindly. Dave Kuhn |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ifference between times rounding up or down the minutes to .25... | Excel Worksheet Functions | |||
| Adding minutes to Times | Excel Worksheet Functions | |||
| how do I calculate minutes when given two times? | Excel Worksheet Functions | |||
| Excel, how do you add times with minutes more than 60 | New Users to Excel | |||
| how do i calculate minutes between two times? | Excel Discussion (Misc queries) | |||
Threaded Mode
