LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
pol pol is offline
external usenet poster
 
Posts: 129
Default To calculate the working hrs of employee in excel

I have an excel sheet with opening hrs and closing hrs of the business . Then
Inhave to find out the working hrs.

A1 cell contain opeining hrs and B1 cell contain closing cell

A1 cell value = 8.50 AM
B1 Cell value = 17.40 PM.

Please hw I can find out the working hrs as 8.40 .

with thanks and regards
Pol
 
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
need excel template to calculate employee time for day mommiecani Excel Discussion (Misc queries) 2 October 7th 06 04:45 PM
need excel template to calculate employee time in/out for day mommiecani Excel Discussion (Misc queries) 1 October 7th 06 04:09 PM
how to calculate the age of an employee Grd New Users to Excel 13 September 19th 06 06:11 PM
Calculate employee hours for employee evaluation? Triesha Excel Worksheet Functions 3 February 9th 06 02:52 PM
How do I calculate an employee timesheet in Excel? Raven Excel Worksheet Functions 1 October 3rd 05 07:20 PM


All times are GMT +1. The time now is 12:05 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"