Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
To calculate the working hrs of employee in excel
=B1-A1
and format as time, such as h:mm -- __________________________________ HTH Bob "pol" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
To calculate the working hrs of employee in excel
Firstly, use 8:50 (with a colon) instead of 8.50 (with a full stop)
Secondly, use either 17:40 (24 hour clock) or 5:40 PM (12 hour clock) Thirdly, if you are using the 12 hour clock, use one (and only one) space between the 5:40 and the PM, not 2 spaces as you have If you deal with those, =B1-A1 will give you 8:50 If you want 8:40, you'll need to subtract 10 minutes, so =B1-A1-TIME(0,10,0) You could, of course, devise a formula to correct some of the errors above, but you'll need to know what range of possible errors you are trying to deal with. -- David Biddulph "pol" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need excel template to calculate employee time for day | Excel Discussion (Misc queries) | |||
need excel template to calculate employee time in/out for day | Excel Discussion (Misc queries) | |||
how to calculate the age of an employee | New Users to Excel | |||
Calculate employee hours for employee evaluation? | Excel Worksheet Functions | |||
How do I calculate an employee timesheet in Excel? | Excel Worksheet Functions |