| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Formula
I was given a file that looks like this:
Day of Wk Time Number of Minutes Tuesday 1148A 3 Tuesday 1151A 1 Wednesday 0301P 1 Sunday 1202P 5 Saturday 0530P 2 Monday 0542P 10 Trying to determin how many minutes were spent on the phone during non-work days/times (M-F, 8-5) 1. How do I convert the time into a useable format? 2. Please help w/formula |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time formula, complicated? | Excel Discussion (Misc queries) | |||
| How do I write the formula to calculate someones time worked | Excel Worksheet Functions | |||
| Formula is entering a default time when it comes across an empty cell.. | Excel Worksheet Functions | |||
| Formula to deduct unpaid breaks in time sheet | Excel Discussion (Misc queries) | |||
| time formula question... | Excel Discussion (Misc queries) | |||
Threaded Mode
