Meeting Duration between two columns to a seperate worksheet

rolandeckstein

New Member
Joined
Aug 3, 2010
Messages
24
if i wanted to add an abs value formula into that, where would i put it. As of right now im using the same formula for meeting duration, subtracting one column from the other. and its not pickin up a select few pairs that come up negative, for example, 1:00 pm to 11:15 AM, when subtracted

= F10-D10
="11:15 AM" - 1:00 PM

it comes to -0.07292

therefore i need to add an absolute value into this formula:

=SUM(IF(July!F4:F1000003*July!D4:D1000003,(July!F4:F1000003-July!D4:D1000003<=0.5)+0))

if i wanted to add an abs value formula into that, where would i put it and is that what would do the trick to find out the correct meeting duration.
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

p45cal

Well-known Member
Joined
Nov 10, 2009
Messages
4,763
It's probably because the times are reversed; a meeting from 1pm to 11:15am is an all nighter. There should be no problem at all subtracting times which don't cross midnight.
However, if the entries are reversed a simple =ABS(F10-D10) should do it. but I wouldn't do it, I'd want to be alerted that times were swapped.
 

Watch MrExcel Video

Forum statistics

Threads
1,133,576
Messages
5,659,622
Members
418,515
Latest member
tobyvb

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top