| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate difffernce in time in attendane eg 0830 - 1750
How do I calculate time difference in hours in my attendance records, eg 0850
to 1950 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculate difffernce in time in attendane eg 0830 - 1750
=(end_time-start_time)*24
and format as general -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Fabricare" wrote in message ... How do I calculate time difference in hours in my attendance records, eg 0850 to 1950 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| time sheet drop down lists | Excel Discussion (Misc queries) | |||
| How do I calculate time durations over numerous dates | Excel Worksheet Functions | |||
| Calculate the time an employee signed in and out plus rate per hr | Excel Discussion (Misc queries) | |||
| How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) | |||
| calculate negative or positve difference in time | Excel Discussion (Misc queries) | |||
Linear Mode
