Time Calculation

B

Brandy

The numbers are not coming out correctly. Each column is
formatted as 35:30:55.

Column Q - time kid came in
Column N - time kid left

Column U - (N6-Q6)

Cell AB10 - =SUM(U:U)

It is off by at least 7 hours. Any ideas why this is
happening?
 
G

Guest

-----Original Message-----
Hi
format the cells with the custom format
[hh]:mm:ss

--
Regards
Frank Kabel
Frankfurt, Germany

The numbers are not coming out correctly. Each column is
formatted as 35:30:55.

Column Q - time kid came in
Column N - time kid left

Column U - (N6-Q6)

Cell AB10 - =SUM(U:U)

It is off by at least 7 hours. Any ideas why this is
happening?
Click to expand...

.
Click to expand...
 
B

Brandy

Yes, That is how it is formatted - 37:30:55

-----Original Message-----
Hi
format the cells with the custom format
[hh]:mm:ss

--
Regards
Frank Kabel
Frankfurt, Germany

The numbers are not coming out correctly. Each column is
formatted as 35:30:55.

Column Q - time kid came in
Column N - time kid left

Column U - (N6-Q6)

Cell AB10 - =SUM(U:U)

It is off by at least 7 hours. Any ideas why this is
happening?
Click to expand...

.
Click to expand...
 
F

Frank Kabel

Hi
could you then post some example data and your incorrect result for
this example

--
Regards
Frank Kabel
Frankfurt, Germany

Brandy said:
Yes, That is how it is formatted - 37:30:55

-----Original Message-----
Hi
format the cells with the custom format
[hh]:mm:ss

--
Regards
Frank Kabel
Frankfurt, Germany

The numbers are not coming out correctly. Each column is
formatted as 35:30:55.

Column Q - time kid came in
Column N - time kid left

Column U - (N6-Q6)

Cell AB10 - =SUM(U:U)

It is off by at least 7 hours. Any ideas why this is
happening?
Click to expand...

.
Click to expand...
Click to expand...
 
B

Brandy

Thanks -

So 2:35 p.m. to 6:45 p.m. should equal 4 hours and 10
minutes. I am using military time.

Column N = 14:35:00
Column Q = 18:45:00
Column U = 4:10:00

Then in cell AB10, the formula was =SUM(U:U)

AB10 is several hours off of the hand count I am doing to
check the program.

Does that make sense?



-----Original Message-----
Hi
could you then post some example data and your incorrect result for
this example

--
Regards
Frank Kabel
Frankfurt, Germany

Yes, That is how it is formatted - 37:30:55

-----Original Message-----
Hi
format the cells with the custom format
[hh]:mm:ss

--
Regards
Frank Kabel
Frankfurt, Germany

"Brandy" <[email protected]> schrieb
Click to expand...
im
Newsbeitrag
The numbers are not coming out correctly. Each
Click to expand...
column
is
formatted as 35:30:55.

Column Q - time kid came in
Column N - time kid left

Column U - (N6-Q6)

Cell AB10 - =SUM(U:U)

It is off by at least 7 hours. Any ideas why this is
happening?

.
Click to expand...
Click to expand...

.
Click to expand...
 
F

Frank Kabel

Hi
my assumption still would be that you have to format the resulting cell
with
[hh]:mm:ss
note the square brackets. They prevent that Excel starts with zero
again after 24 hours. If you like, email me your file and I#ll have a
look at it


--
Regards
Frank Kabel
Frankfurt, Germany

Brandy said:
Thanks -

So 2:35 p.m. to 6:45 p.m. should equal 4 hours and 10
minutes. I am using military time.

Column N = 14:35:00
Column Q = 18:45:00
Column U = 4:10:00

Then in cell AB10, the formula was =SUM(U:U)

AB10 is several hours off of the hand count I am doing to
check the program.

Does that make sense?



-----Original Message-----
Hi
could you then post some example data and your incorrect result for
this example

--
Regards
Frank Kabel
Frankfurt, Germany

Yes, That is how it is formatted - 37:30:55


-----Original Message-----
Hi
format the cells with the custom format
[hh]:mm:ss

--
Regards
Frank Kabel
Frankfurt, Germany

Newsbeitrag
The numbers are not coming out correctly. Each column
is
formatted as 35:30:55.

Column Q - time kid came in
Column N - time kid left

Column U - (N6-Q6)

Cell AB10 - =SUM(U:U)

It is off by at least 7 hours. Any ideas why this is
happening?

.
Click to expand...

.
Click to expand...
Click to expand...
 
B

Brandy

The formatting with brackets is not an option in my
program. I have emailed it to you to look at. Thanks for
your help.

Brandy
-----Original Message-----
Hi
my assumption still would be that you have to format the resulting cell
with
[hh]:mm:ss
note the square brackets. They prevent that Excel starts with zero
again after 24 hours. If you like, email me your file and I#ll have a
look at it


--
Regards
Frank Kabel
Frankfurt, Germany

Thanks -

So 2:35 p.m. to 6:45 p.m. should equal 4 hours and 10
minutes. I am using military time.

Column N = 14:35:00
Column Q = 18:45:00
Column U = 4:10:00

Then in cell AB10, the formula was =SUM(U:U)

AB10 is several hours off of the hand count I am doing to
check the program.

Does that make sense?



-----Original Message-----
Hi
could you then post some example data and your
Click to expand...
incorrect
result for
this example

--
Regards
Frank Kabel
Frankfurt, Germany

"Brandy" <[email protected]> schrieb
Click to expand...
im
Newsbeitrag
Yes, That is how it is formatted - 37:30:55


-----Original Message-----
Hi
format the cells with the custom format
[hh]:mm:ss

--
Regards
Frank Kabel
Frankfurt, Germany

"Brandy" <[email protected]>
Click to expand...
schrieb
im
Newsbeitrag
The numbers are not coming out correctly. Each column
is
formatted as 35:30:55.

Column Q - time kid came in
Column N - time kid left

Column U - (N6-Q6)

Cell AB10 - =SUM(U:U)

It is off by at least 7 hours. Any ideas why this is
happening?

.


.
Click to expand...
Click to expand...

.
Click to expand...
 
F

Frank Kabel

Hi
you have to enter this as custom format. Try the following:
- select this cell
- goto 'Format - Cells'
- choose 'Custom'. This should be the last entry in the left listbox
- now MANUALLY enter this format in the right-textbox. Just overwrite
what is in this boy with [hh]:mm:ss

--
Regards
Frank Kabel
Frankfurt, Germany

Brandy said:
The formatting with brackets is not an option in my
program. I have emailed it to you to look at. Thanks for
your help.

Brandy
-----Original Message-----
Hi
my assumption still would be that you have to format the resulting cell
with
[hh]:mm:ss
note the square brackets. They prevent that Excel starts with zero
again after 24 hours. If you like, email me your file and I#ll have a
look at it


--
Regards
Frank Kabel
Frankfurt, Germany

Thanks -

So 2:35 p.m. to 6:45 p.m. should equal 4 hours and 10
minutes. I am using military time.

Column N = 14:35:00
Column Q = 18:45:00
Column U = 4:10:00

Then in cell AB10, the formula was =SUM(U:U)

AB10 is several hours off of the hand count I am doing to
check the program.

Does that make sense?




-----Original Message-----
Hi
could you then post some example data and your incorrect
result for
this example

--
Regards
Frank Kabel
Frankfurt, Germany

Newsbeitrag
Yes, That is how it is formatted - 37:30:55


-----Original Message-----
Hi
format the cells with the custom format
[hh]:mm:ss

--
Regards
Frank Kabel
Frankfurt, Germany

im
Newsbeitrag
The numbers are not coming out correctly. Each
column
is
formatted as 35:30:55.

Column Q - time kid came in
Column N - time kid left

Column U - (N6-Q6)

Cell AB10 - =SUM(U:U)

It is off by at least 7 hours. Any ideas why this is
happening?

.


.
Click to expand...

.
Click to expand...
Click to expand...
 
B

Brandy

I have done that - but the numbers are still the same...
and wrong.

-----Original Message-----
Hi
you have to enter this as custom format. Try the following:
- select this cell
- goto 'Format - Cells'
- choose 'Custom'. This should be the last entry in the left listbox
- now MANUALLY enter this format in the right-textbox. Just overwrite
what is in this boy with [hh]:mm:ss

--
Regards
Frank Kabel
Frankfurt, Germany

The formatting with brackets is not an option in my
program. I have emailed it to you to look at. Thanks for
your help.

Brandy
-----Original Message-----
Hi
my assumption still would be that you have to format
Click to expand...
the
resulting cell
with
[hh]:mm:ss
note the square brackets. They prevent that Excel
Click to expand...
starts
with zero
again after 24 hours. If you like, email me your file
Click to expand...
and
I#ll have a
look at it


--
Regards
Frank Kabel
Frankfurt, Germany

"Brandy" <[email protected]> schrieb
Click to expand...
im
Newsbeitrag
Thanks -

So 2:35 p.m. to 6:45 p.m. should equal 4 hours and 10
minutes. I am using military time.

Column N = 14:35:00
Column Q = 18:45:00
Column U = 4:10:00

Then in cell AB10, the formula was =SUM(U:U)

AB10 is several hours off of the hand count I am
Click to expand...
doing
to
check the program.

Does that make sense?




-----Original Message-----
Hi
could you then post some example data and your incorrect
result for
this example

--
Regards
Frank Kabel
Frankfurt, Germany

"Brandy" <[email protected]>
Click to expand...
schrieb
im
Newsbeitrag
Yes, That is how it is formatted - 37:30:55


-----Original Message-----
Hi
format the cells with the custom format
[hh]:mm:ss

--
Regards
Frank Kabel
Frankfurt, Germany

im
Newsbeitrag
The numbers are not coming out correctly. Each
column
is
formatted as 35:30:55.

Column Q - time kid came in
Column N - time kid left

Column U - (N6-Q6)

Cell AB10 - =SUM(U:U)

It is off by at least 7 hours. Any ideas why this is
happening?

.


.


.
Click to expand...
Click to expand...

.
Click to expand...
 
F

Frank Kabel

Hi
the problem is that you have negative values in your range (showing as
#####). These values are summed as well in your final result. So you
have to define what your happen with these values

--
Regards
Frank Kabel
Frankfurt, Germany

Brandy said:
I have done that - but the numbers are still the same...
and wrong.

-----Original Message-----
Hi
you have to enter this as custom format. Try the following:
- select this cell
- goto 'Format - Cells'
- choose 'Custom'. This should be the last entry in the left listbox
- now MANUALLY enter this format in the right-textbox. Just overwrite
what is in this boy with [hh]:mm:ss

--
Regards
Frank Kabel
Frankfurt, Germany

The formatting with brackets is not an option in my
program. I have emailed it to you to look at. Thanks for
your help.

Brandy
-----Original Message-----
Hi
my assumption still would be that you have to format the
resulting cell
with
[hh]:mm:ss
note the square brackets. They prevent that Excel starts
with zero
again after 24 hours. If you like, email me your file and
I#ll have a
look at it


--
Regards
Frank Kabel
Frankfurt, Germany

Newsbeitrag
Thanks -

So 2:35 p.m. to 6:45 p.m. should equal 4 hours and 10
minutes. I am using military time.

Column N = 14:35:00
Column Q = 18:45:00
Column U = 4:10:00

Then in cell AB10, the formula was =SUM(U:U)

AB10 is several hours off of the hand count I am doing
to
check the program.

Does that make sense?




-----Original Message-----
Hi
could you then post some example data and your
incorrect
result for
this example

--
Regards
Frank Kabel
Frankfurt, Germany

im
Newsbeitrag
Yes, That is how it is formatted - 37:30:55


-----Original Message-----
Hi
format the cells with the custom format
[hh]:mm:ss

--
Regards
Frank Kabel
Frankfurt, Germany

"Brandy" <[email protected]>
schrieb
im
Newsbeitrag
The numbers are not coming out correctly. Each
column
is
formatted as 35:30:55.

Column Q - time kid came in
Column N - time kid left

Column U - (N6-Q6)

Cell AB10 - =SUM(U:U)

It is off by at least 7 hours. Any ideas why
this is
happening?

.


.


.
Click to expand...

.
Click to expand...
Click to expand...
 
Top