| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SUBTRACTING TIME VALUES INSTEAD OF DECIMAL!!
Please help! I have used the 00:\00:\00 format to input times without having
to press the colon every time. Now though, when Excel tries to minus one time from another, because of the custom format it only recognizes times as numbers... e.g. 12:15:30 - 12:14:50 Excel thinks this equals 00:00:80!! Can anybody help? How do I get it to recognise that the answer is 00:01:20 ? Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time Values | Excel Discussion (Misc queries) | |||
| If Statement - in time not decimal minutes | Excel Worksheet Functions | |||
| How do you find the difference between two time values when one i. | Excel Discussion (Misc queries) | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| How to convert decimal values (dd.dddddd) to degrees/minutes/seco. | Excel Worksheet Functions | |||
Threaded Mode
