| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate time in a cell
I have a spread sheet that I keep the employees schedule in. What I'm trying
to do is let excel keep a tally of total hours for me. A13 Has Carol B13 has 5:30-14:30 <~~ which are her hours for that day. then C13, D13, E13, F13 etc etc has her schedule input the same way. (24 hour clock) In addition to keeping a tally of total hours, can it also subtract 30 minutes per day for a lunch break? I've tried all I know and nothing works. Thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why do I have to enter the cell (F2) for cell to calculate? | Excel Discussion (Misc queries) | |||
| enter a time into a cell, have the cell show two times the entry | Excel Worksheet Functions | |||
| calculate difference in time to hours | Excel Worksheet Functions | |||
| How do I get one cell to record the time another cell was changed. | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
