| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can i calculate overtime give formula for 24 hrs clock
Next time use the word "please" as well
=MOD(end-start,1) will give you a correct time value if start is before midnight and end is after. -- Regards, Peo Sjoblom "Sanjay Raut" <Sanjay wrote in message ... When I try to calculate the overtime of the Evenign AND Night shift the time will not calculate exactley.. give me some 1 formula which show me the different of the time between login and logout. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Formula to Calculate Time/Overtime | Excel Discussion (Misc queries) | |||
| How do I calculate time in excel (clock in and clock out | Excel Discussion (Misc queries) | |||
| I want to calculate overtime hours for employees | Excel Worksheet Functions | |||
| How can I calculate overtime? | Excel Discussion (Misc queries) | |||
| Could you help me to calculate overtime | Excel Worksheet Functions | |||
![Peo Sjoblom[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
