Re: excel should allow to add and subtract times

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: tjtjjtjt (tjtjjtjt_at_discussions.microsoft.com)
Date: 12/10/04 

Date: Fri, 10 Dec 2004 15:09:02 -0800

What problem are you having exactly?
If I put your times in four cells:
8:45 in A1
12:30 in A2
1:00 in A3
5:00 in A5
and then put the following formula in A5: =(A2-A1)+(A4-A3), I get 7:45.
For A5, I set the Format to a a Custom Format of [h]:mm. For the other four
cells, I just Excel recognize the times I typed in. Why not go to Format |
Cells and look at some of the Time Formats? Using one of them will avoid you
having to work with TEXT or INT.

What formulas on these pages use INT?
http://www.cpearson.com/excel/datearith.htm#AddingTimes
http://www.cpearson.com/excel/overtime.htm

tj

Also, which formulas on this page use INT?

"LV" wrote:

> Paul,
>
> Thanks for your help, but all of those functions use the INT function, which
> rounds to the nearest integer.
>
> Say some one come in at 8:45 AM, leaves for Lunch at 12:30, Returns at 1:00,
> and leaves the office at 5:00 PM. I need to automate finding the amount of
> hours that individual worked (7.75) I know it seems lazy, but it would help
> me out in my daily tasks.
>
> LV
>
> "Paul B" wrote:
>
> > LV, excel will add and subtract time, see here for some help
> > http://www.cpearson.com/excel/datetime.htm#AddingTimes
> >
> > --
> > Paul B
> > Always backup your data before trying something new
> > Please post any response to the newsgroups so others can benefit from it
> > Feedback on answers is always appreciated!
> > Using Excel 2002 & 2003
> >
> > "LV" <LV@discussions.microsoft.com> wrote in message
> > news:5C3E1E64-2207-4F65-9FEA-482A2CFA61F2@microsoft.com...
> > > The INT and TEXT Functions are insufficent. I need to automate filling out
> > > time cards for multiple people. INT only calculates whole hours and TEXT
> > is
> > > not summable.
> >
> >
> >

Relevant Pages

  • Re: Excel date conversion in .NET
    ... When I look at the excel file and examine the cell format, ... My cells actually contained a date with time which in excel format ... int strDD; ...
    (microsoft.public.excel.programming)
  • [PATCH] new bitmap list format (for cpusets)
    ... A bitmap print and parse format that provides lists of ranges of ... The intention is to provide a format for the cpu and memory mask files ... extern int bitmap_parse(const char __user *ubuf, unsigned int ulen, ...
    (Linux-Kernel)
  • Re: [Lse-tech] [PATCH] new bitmap list format (for cpusets)
    ... came to the conclusion that the basic list format, ... So I redid the bitmap list format patch, ... A bitmap print and parse format that provides lists of ranges of ... extern int bitmap_parse(const char __user *ubuf, unsigned int ulen, ...
    (Linux-Kernel)
  • Explanation - Union doesnt work with format mergecells...
    ... I want to ensure the formats after someone make cut and past, drag and drop ... If so, the format vanishes. ... Since there is a lot of different cells, ... .ReadingOrder = xlContext ...
    (microsoft.public.excel.programming)
  • [PATCH] new bitmap list format (for cpusets)
    ... [This is a copy of the bitmap list format patch that I submitted to ... A bitmap print and parse format that provides lists of ranges of ... extern int bitmap_parse(const char __user *ubuf, unsigned int ulen, ...
    (Linux-Kernel)