Calculating Time

[Fyr]

I have a problem when trying to add up time.
I have 4 columns, C, D, E, F.
For example,

  C(IN)         D(OUT)          E(IN)           F(OUT)          
7:30 AM        11:30 AM       12:30 PM         4:30 PM

I'm trying to calculate these to display how many hours a worker worked.
In this case, it will be 8 hours. But when trying to calculate this, it doesn't seem to work.
This is what I'm using to calculate. By the way, i'm calculating this from another worksheet.

=SUM(table!D:D,-table!C:C)+SUM(table!F:F,-table!E:E)

Specifying the actual column and row works, but since there will be more time in the columns, i will be adding/subtracting by column.

thanks for taking a look.

 

[Fyr]

oops, nevermind, i figured it out.
I needed to calculate the columns first, then add column to column.
This is what I used,

=SUM(table!D:D)-SUM(table!C:C)+SUM(table!F:F)-SUM(table!E:E)

 

[Fyr]

ok, it didn't work after all.
I entered some times, and after row 3, it went back to zero time.

when adding the first row, it came up as 8 hours, when adding the second row in showed as 16 hours. But when adding the third row, it went back to zero.

       C(IN)         D(OUT)          E(IN)           F(OUT)          
[1]  7:30 AM        11:30 AM       12:30 PM         4:30 PM
[2]  7:30 AM        11:30 AM       12:30 PM         4:30 PM
[3]  7:30 AM        11:30 AM       12:30 PM         4:30 PM

 

[VoG]

Format the result cell as Custom [h]:mm

 

[Fyr]

I tried that, but the calculation is still wrong somehow.
There's just a one row entry with:

       C(IN)         D(OUT)          E(IN)           F(OUT)          
[1]  7:30 AM        11:30 AM       12:30 PM         4:30 PM

And on the calcualtion page, it's showing 28:00 when it should be 8:00.