LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 788
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I calculate the difference between 11:00pm and 7:00am candros Excel Discussion (Misc queries) 4 March 31st 09 08:24 PM
cannot type in cells, time format 12:00am monkeyboy Excel Discussion (Misc queries) 1 March 27th 08 08:52 AM
Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis Graham Excel Discussion (Misc queries) 2 January 28th 07 08:40 PM
'09:00AM trying to get remove the apostrophe Kazza Excel Discussion (Misc queries) 1 April 25th 06 10:57 AM
Time formula 0600 = 11:00AM Aashish Excel Discussion (Misc queries) 1 March 24th 05 04:43 PM


All times are GMT +1. The time now is 11:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"