Re: calculating worktime minus lunch

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Harald Staff (innocent_at_enron.invalid)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 11:44:05 +0200

Hi

First: Enter time as time, with colons, not decimal points. See
http://www.cpearson.com/excel/datetime.htm on this.

Then see http://www.cpearson.com/excel/overtime.htm for a working sample. 

--
HTH. Best wishes Harald
Followup to newsgroup only please
"svenne >" <<svenne.13xbp4@excelforum-nospam.com> skrev i melding
news:svenne.13xbp4@excelforum-nospam.com...
> I'm trying to do a exceldocument where I fill in the time I start, the
> time I finish minus how long lunch I had in hours or minutes. I also
> need to calculate how much over or undertime I have worked, standard
> hour is 8 hours.
> here is an example how it could look, its the calculations thats
> important.
>
>
> start         end        lunch         totaltime
> over/under-time
> 08.15        17.00     1 h             7 h 45 min                  -15
>
> 07.45        17.15     0.45 min     8 h 45 min     +45
>
>
>
> please ask if something is unclear.
> thx
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

Relevant Pages

  • Re: search macro
    ... HTH. ... Best wishes Harald ... Followup to newsgroup only please. ...
    (microsoft.public.excel.misc)
  • Re: Sorting VBA?
    ... Autofilter for hiding dates outside the interval. ... HTH. ... Best wishes Harald ... Followup to newsgroup only please ...
    (microsoft.public.excel.programming)
  • Re: Cell Comparison
    ... HTH. ... Best wishes Harald ... Followup to newsgroup only please ...
    (microsoft.public.excel.misc)
  • Re: Symbols
    ... HTH. ... Best wishes Harald ... Followup to newsgroup only please. ...
    (microsoft.public.excel)
  • Re: Problem with Formulas
    ... to overcome possible text entries. ... Ensure also that calculation is set to Automatic in Tools> Options. ... HTH. ... Best wishes Harald ...
    (microsoft.public.excel.worksheet.functions)