| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can i calculate overtime give formula for 24 hrs clock
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can i calculate overtime give formula for 24 hrs clock
If you have day and time in the same cell, then difference would be
end - start If you have date in a different cell and people work overnight, then you need to have end date - start date + end time - start time Format cells as hh:mm "Sanjay Raut" wrote: 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. |
|
#3
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 | |||
Linear Mode
