| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel, how do you add times with minutes more than 60
How do you add numbers that are not in time format? They are not in time
format as it is for addition purposes only i.e. If I worked 7 hours 1 day and 7.85 hours the next it should read 15.15 hours and minutes in total. If using the time format it will read the results as time i.e. 15:15 in the afternoon, this is the wrong result. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel won't allow times to be negative | Excel Discussion (Misc queries) | |||
| Excel should be able to format 12-hour times without am/pm | Excel Discussion (Misc queries) | |||
| Adding/Averaging Times in Excel | Excel Discussion (Misc queries) | |||
| How do I duplicate a sheet 20 times in an excel spreadsheet | Excel Worksheet Functions | |||
Threaded Mode
