accurate

Thanks to all who respond. I am using the FLOOR function with a 2:30 time interval to group my time cells but because of the rounding it is not 100% accurate for grouping. See the bold items below. I want to group the records that are within 2:30 from the previous record. 6:12:31 0.2587...

<colgroup><col><col><col><col></colgroup><tbody> <colgroup><col></colgroup><tbody> Hi, refer to attachment, I'd like to find out how many time the email at column A appears at col. B (within the same row only. Eg. A1 with B1, A2 with B2). Currently I have this formula as appeared at col. C1...

I'm trying to figure out 2 different sets of projections and whose projections where the most accurate. The data looks like this: Proj 1 Proj 2 Actual23 25 27 24 29 16 33 37 26 8 16 33 The...

I am trying to get the average idle time in-between two-time stamps. when I do so I get a number I don't believe is accurate. depending on the format it shows weird times one being 3 hours and another being 13:3:3:53 when formatted with days but I know it doesn't mean 13 is days. When the...

Does anyone know how to calculate between 2 numbers. Example - one report has to pay accurately which is between 95%-102% (we count these as accurate). another report has to pay the same way (these 2 never match since they pull from different sources). I need a formula to show if these 2...

I have several textboxes that I want to format as currency, and several others that I want to format as date (MM/DD/YY). When I say format, I'm referring to displaying the desired format in the textboxes themselves. I realize that I can format the textboxes individually, but I'm curious if...