to find out time
 

Please help to write a macors


totalworkinghrs = 8.00
latehrs = .10
The effective hrs should be = 7.50

Please anybody can give me a solution

With thanks
Pol

to find out time
 

Hi,

=TEXT(B1-B2,"H.m")

change range to fit your needs

"pol" wrote:

Please help to write a macors


totalworkinghrs = 8.00
latehrs = .10
The effective hrs should be = 7.50

Please anybody can give me a solution

With thanks
Pol

to find out time
 

Your question does not make sense. The total working hours is 8.0 The late
hours is 0.1

0.1 hours is either 0.1 * 60min = 6min
or it is 10 minutes.

In either case the math does not add up to 7.5 hours. What is your logic?
--
HTH...

Jim Thomlinson


"pol" wrote:

Please help to write a macors


totalworkinghrs = 8.00
latehrs = .10
The effective hrs should be = 7.50

Please anybody can give me a solution

With thanks
Pol

to find out time
 

Sorry for that

..10 indicates 10 mts.

Please help to write a general logic

"Jim Thomlinson" wrote:

Your question does not make sense. The total working hours is 8.0 The late
hours is 0.1

0.1 hours is either 0.1 * 60min = 6min
or it is 10 minutes.

In either case the math does not add up to 7.5 hours. What is your logic?
--
HTH...

Jim Thomlinson


"pol" wrote:

Please help to write a macors


totalworkinghrs = 8.00
latehrs = .10
The effective hrs should be = 7.50

Please anybody can give me a solution

With thanks
Pol

to find out time
 

See the formula given before is working for me

"pol" wrote:

Sorry for that

.10 indicates 10 mts.

Please help to write a general logic

"Jim Thomlinson" wrote:

Your question does not make sense. The total working hours is 8.0 The late
hours is 0.1

0.1 hours is either 0.1 * 60min = 6min
or it is 10 minutes.

In either case the math does not add up to 7.5 hours. What is your logic?
--
HTH...

Jim Thomlinson


"pol" wrote:

Please help to write a macors


totalworkinghrs = 8.00
latehrs = .10
The effective hrs should be = 7.50

Please anybody can give me a solution

With thanks
Pol

to find out time
 

What you are asking for will end up giving you more problems than it it
worth. You should be entering things as actual times. Doing that XL will be
ablle to add and subtract times with ease. What you are asking for is going
to result in a lot of formulas/macros that are extremely complex to manage. I
highly recommend that you re-engineer your solution around using actual time
entry.
--
HTH...

Jim Thomlinson


"pol" wrote:

Sorry for that

.10 indicates 10 mts.

Please help to write a general logic

"Jim Thomlinson" wrote:

Your question does not make sense. The total working hours is 8.0 The late
hours is 0.1

0.1 hours is either 0.1 * 60min = 6min
or it is 10 minutes.

In either case the math does not add up to 7.5 hours. What is your logic?
--
HTH...

Jim Thomlinson


"pol" wrote:

Please help to write a macors


totalworkinghrs = 8.00
latehrs = .10
The effective hrs should be = 7.50

Please anybody can give me a solution

With thanks
Pol