Re: Summing Time Data
From: JE McGimpsey (jemcgimpsey_at_mvps.org)
Date: 01/04/05
- Next message: P-A Caron: "Is there a way to password protect a column?"
- Previous message: Anthony Slater: "RE: how do i get mutiple values using vlookup in excel, lookup value ."
- In reply to: AJG: "Summing Time Data"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 04 Jan 2005 07:32:32 -0700
SUM() ignores text, while the + operator will coerce its text arguments
to numeric if it can.
Try coercing your data to actual numeric values (which is how XL stores
times - as fractional days) by copying an empty cell, selecting your
values, choosing Edit/Paste Special, selecting the Values and Add radio
buttons, then clicking OK. Format the result as time.
In article <E858891B-CAAC-4D50-A90E-FB2D6F39AE77@microsoft.com>,
AJG <AJG@discussions.microsoft.com> wrote:
> Is there anyone out there who knows why the SUM function won't work, but
> manual addition will?
- Next message: P-A Caron: "Is there a way to password protect a column?"
- Previous message: Anthony Slater: "RE: how do i get mutiple values using vlookup in excel, lookup value ."
- In reply to: AJG: "Summing Time Data"
- Messages sorted by: [ date ] [ thread ]
