| 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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Excel, how do you add times with minutes more than 60
You may use TIME and FORMAT in the same formula, something like:
=TEXT(TIME(INT(A1),MOD(A1,1)*100,0)+TIME(INT(A2),M OD(A2,1)*100,0),"[hh]:mm") Hope this helps, Miguel. "squeeky" wrote: 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? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Excel, how do you add times with minutes more than 60
Hi Miguel, Worked a treat! Thanks! Made me also realise that my maths was dud
:) Squeeky "Miguel Zapico" wrote: You may use TIME and FORMAT in the same formula, something like: =TEXT(TIME(INT(A1),MOD(A1,1)*100,0)+TIME(INT(A2),M OD(A2,1)*100,0),"[hh]:mm") Hope this helps, Miguel. "squeeky" wrote: 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? |
| Reply |
| 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 | |||
Hybrid Mode
