LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 27
Default Still problems with calculation of time

I have already had very good help, but unfortunately, none of the solutions
which can handle the needs I have to consider.

I can only make a form that works properly, either when finishing is before
24:00 or after 24:00. I can not make a form that can handle END times both
before and after 24:00.

So I have to just to try once mo)

I would be very happy if I could get help to produce a formula which is able
to calculate hours in a time when "finishing" can be both before and after
at. 24:00.

I can only make a formular, who works

For example: Start: 16:00, End: 6:00 total hours = 14 ,
and hours of these between 18:00 to 22:00 = 4

and another example: Start: 16:00, End: 21:00 total hours = 6,
and hours of these between 18:00 to 22:00 = 3

It is the counting of the time between 18:00 and 22:00 there is a problem,
totaltid is not necessary to count.

Sincerely,
H. Nissen
 
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
Application.Calculation Problems Jive Excel Worksheet Functions 2 February 7th 08 02:21 PM
Excel 2007 - Calculation Problems Alan Smith Excel Discussion (Misc queries) 12 December 14th 07 02:41 PM
Excel 2003 - Problems with calculation ROland Setting up and Configuration of Excel 1 January 16th 07 03:21 PM
Time format - problems with calculation Kathrine Excel Discussion (Misc queries) 1 December 5th 06 02:20 PM
Simple Interest Calculation Problems Lisa Excel Discussion (Misc queries) 1 March 2nd 06 03:27 PM


All times are GMT +1. The time now is 05:34 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"