| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time difference - again!
Sorry I know it has been covered but nothing works for me.
Maybe it's my formating. Cell A1=10am (format is '*1:30:55 PM' from the Format Cells dialogue box - Time/Type) Cell B1=5:30pm (format is '*1:30:55 PM' from the Format Cells dialogue box - Time/Type) No matter what I do eg '=B1-A1' or many other formulae I still get #VALUE error. I want to know in number format the number of hours elapsed. Will NOT be greater than 24. -- Regards Tom |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time difference calculation | Excel Worksheet Functions | |||
| Average Time Difference | Excel Worksheet Functions | |||
| Calculating time difference over midnight! | Excel Discussion (Misc queries) | |||
| What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel | |||
| Time / Formula to look at time difference | Excel Worksheet Functions | |||
Threaded Mode
