| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate cells with format hh:mm
In Out Hours
16:00 18:30 02:30 08:55 15:00 06:05 12:00 21:00 09:00 10:00 16:00 06:00 08:45 16:35 07:50 08:00 20:30 12:30 I have a hourlist like this, the hours are in format hh:mm, what I hope to manage is.. lets call the columns A B C D IN OUT HOURS AFTER 18 in column D i want to have all hours after 18:00 listet automaticly, so if a worker works to 19:30 the col. D should list 1:30 Is this possible with the HH:MM format?? -- Just a regular user |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How calculate difference between [t]:mm-format and general format | Excel Worksheet Functions | |||
| How can I calculate hours into pay...in this format hh:mm:ss | Excel Discussion (Misc queries) | |||
| Format Cells to calculate hours and minutes taken to complete task | Excel Worksheet Functions | |||
| want format cells alignment not format cells font style | Excel Discussion (Misc queries) | |||
| How do I only calculate cells which have a filled color format? | Excel Discussion (Misc queries) | |||
Threaded Mode
