| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Best Available time | Excel Worksheet Functions | |||
| find the difference between start time and end time when spanning. | Excel Discussion (Misc queries) | |||
| verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
| Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
| How can i find time in various time zone? | New Users to Excel | |||
Linear Mode
