| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i calcalate hours above 7am and 19:00am leaving 12 hrs
how do i calcalate hours above 7am and below 19:00am leaving 12 hrs on a %
basis. So if i work 06:30 and finsih at 18:30 that is 30 minutes as a % rate Also if i work 14:00 and finish at 2am so thats is 7hours % rate |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i calcalate hours above 7am and 19:00am leaving 12 hrs
I think you need to word the problem more precisely, especially what you
mean by percentage best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Chris" wrote in message ... how do i calcalate hours above 7am and below 19:00am leaving 12 hrs on a % basis. So if i work 06:30 and finsih at 18:30 that is 30 minutes as a % rate Also if i work 14:00 and finish at 2am so thats is 7hours % rate |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i calcalate hours above 7am and 19:00am leaving 12 hrs
Hi,
Take a look at C Pearson Web http://www.cpearson.com Go to topics and look into timesheet "Chris" wrote: how do i calcalate hours above 7am and below 19:00am leaving 12 hrs on a % basis. So if i work 06:30 and finsih at 18:30 that is 30 minutes as a % rate Also if i work 14:00 and finish at 2am so thats is 7hours % rate |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate the difference between 11:00pm and 7:00am | Excel Discussion (Misc queries) | |||
| cannot type in cells, time format 12:00am | Excel Discussion (Misc queries) | |||
| Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis | Excel Discussion (Misc queries) | |||
| '09:00AM trying to get remove the apostrophe | Excel Discussion (Misc queries) | |||
| Time formula 0600 = 11:00AM | Excel Discussion (Misc queries) | |||
Linear Mode
