| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Industrial Time look up sheet
Hello,
I am trying to create a time lookup sheet where at the cross point of Start and End time the result is shown in 100 of an hour. So Row 1 has the start time begining at 8.00 am in 15 minutes increments and Colum A has the End time begining also in 15 minutes increments 8.00 am 8.15 am and so on. Now if you look for example at End time 10.30 am and go accros and look for Start time 8.00 am at that cross point the result should say 2.5 (two and a half hours). I do not know what forumla to write for that. Please help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time Sheet - Calculating Time Differences for Totals | Excel Discussion (Misc queries) | |||
| Industrial Limit Switch Interface with Excel | Excel Discussion (Misc queries) | |||
| Detailed Time Sheet (overtime, comp time, vacation used) | New Users to Excel | |||
| How do I time Hours & mins in excel - Time sheet | Excel Discussion (Misc queries) | |||
| I need a time sheet template that verifies time entered against sy | Excel Discussion (Misc queries) | |||
Threaded Mode
