View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
H. Nissen H. Nissen is offline
external usenet poster
 
Posts: 1
Default Calculating of time

Hi

I need to make a sheet, in which i can calculate different ours.

The groundschedule is made with (t):mm and lokes like this:

=IF(G3=$D$3;0;G3)

ex: 15:00 - 05:00 = 14

But I need to calculate how many ours there are ex. from 18:00 to 22:00 and
22:00 to 06:00.

like this:

ex: 15:00 - 05:00 = 12 | 4 | 7
or
ex: 19:00 - 03:00 = 8 | 3 | 5

I hope you understand what i am trying to ask about, and I would be very
happy if someone can help me with this litle problems.

Kinds
H. Nissen