LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,045
Default Help with a formula (calculating totals based on individual percentages

On Wed, 18 Jan 2012 01:23:09 -0800, "joeu2004" wrote:

Displayed timestamps can be deceiving. The clock on my system could be
wrong. For example, this message will appear to be posted on 18 Jan 2012
01:23 AM, apparently a full day before your posting to which I am replying.

(You might even miss it altogether, depending on how you sort things in your
newsreader.)

Fortunately, my newserver adds a header of the form Injection-Date: Thu, 19
Jan 2012 15:44:07 +0000 (UTC). So you might be able to determine the true
date/time when I posted.


OK, trying to sort this out.

Your message, with the OP's solution appears to be posted at:
17 Jan 2012 3:35 PM

By viewing headers, I can see:
Injection-Date: Tue, 17 Jan 2012 20:35:22 +0000 (UTC)

My response appears to have occurred at
17 Jan 2012 4:13 PM

By viewing the headers on that message, I see:
NNTP-Posting-Date: Tue, 17 Jan 2012 15:13:33 -0600
which I would think would be 21:13:33 UTC.

So it appears that the displayed times are probably for real.

I guess it just took a while for your response to get to my news server. Odd.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
calculating the totals of a group of cells based on content of oth ZIPPOMA NEEDS HELP Excel Discussion (Misc queries) 3 October 14th 08 05:41 AM
Calculating percentages based on the number of checked boxes in a column [email protected] Excel Worksheet Functions 7 June 6th 07 01:08 PM
Calculating percentages based on the number of checked boxes in a column [email protected] Excel Discussion (Misc queries) 1 June 6th 07 12:02 PM
Calculating percentages based on a single cell Dimwit Excel Discussion (Misc queries) 2 October 10th 06 03:14 PM
Need formula for calculating totals to range by using multiple cel justaguyfromky Excel Programming 3 December 30th 04 01:03 AM


All times are GMT +1. The time now is 08:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"