| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating diff between date/ time only between certain hours
I am trying to calculate the difference in hours between a date/time range
but only the hours in a certain range. 1/27/10 4:49 1/27/10 11:32 I am trying to find the diff in hours only between 6:00 and 23:59, any hours that fall outside of that time frame should not be counted. Each calculation will have different dates so if there is a way to do this without specifying the date that would be great! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| [NEWBIE] date/time diff | Excel Discussion (Misc queries) | |||
| difference of date/time only calculating workingdays/hours | Excel Worksheet Functions | |||
| calculating time for late hours | Excel Worksheet Functions | |||
| calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
| Calculating time, hours and minutes | Excel Discussion (Misc queries) | |||
Threaded Mode
