| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
hh:mm - mm formated 2 round to .25, .50, .75 & 1
I'm using Excel 2003 - I have a text formula (=TEXT(I14-H14,"h.m")) that I'm
using. The times that I have it calculating are 8:00 AM - 5:30 PM which should be 9.5 hours however it's calculating in 10ths and giving me 9.30 instead. How do I get it formatted to give me 9.50 instead of 9.30? I'm not a Excel "guru" and have looked up most of my formulas on microsoft help. Please help. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round a number in nested function | Excel Worksheet Functions | |||
| Round whole numbers up and down | Excel Discussion (Misc queries) | |||
| Round Up to Nearest 10 | Excel Worksheet Functions | |||
| Round time to nearest quarter hr | Excel Worksheet Functions | |||
| How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
Threaded Mode
