| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time calculation - Critical
Hi,
I have a critical question..,pls check the below and advice me.., I have a cell A1 consisting of date (Imagine its: 15th March 2007) and B1 & B2 consisting of time (Imagine its: start time 09:15am and B2 with end time: 05:00pm) I just need a formula to say the time taken from 09:15am to 05:00pm, and if the time crosses 05:00pm and lies up to next day 08:59am, i should not calculate. Is there any possibility to create a formula for this?. Pls advice.., __Ajay__ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time calculation (Subraction of Idle Time) | Excel Discussion (Misc queries) | |||
| Critical graph | Excel Discussion (Misc queries) | |||
| Why did I get an unexpected critical error? | Excel Discussion (Misc queries) | |||
| Critical thinking puzzle | Excel Discussion (Misc queries) | |||
| Ignoring Time in a Date Time Calculation | Excel Worksheet Functions | |||
Threaded Mode
