| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do you add based on base 60 (minutes) instead of 100
Want to add a column with hours and minutes as 5.32 meaning 5 hours and 32
minutes |
|
#2
|
|||
|
|||
|
Enter it in time format, 5:32
Make sure that the total cell is formatted as [hh]:mm to cater for more than 24 hours. -- HTH Bob Phillips "Mick Stohr" <Mick wrote in message ... Want to add a column with hours and minutes as 5.32 meaning 5 hours and 32 minutes |
|
#3
|
|||
|
|||
|
=SUM(--SUBSTITUTE(IF(A2:A100<"",A2:A100&".0","0.0"),".", ":"))*24
array entered (ctrl+shift+enter) and assuming there is no text in the range "Mick Stohr" <Mick wrote in message ... Want to add a column with hours and minutes as 5.32 meaning 5 hours and 32 minutes |
|
#4
|
|||
|
|||
|
Must have done something wrong. get error message. The subsititute command
seems to give text back so it can't be summed. Dont understand the arrray part. Would prefer using the period since its easier (so i am lazy-efficient). Would you elaborate? "N Harkawat" wrote: =SUM(--SUBSTITUTE(IF(A2:A100<"",A2:A100&".0","0.0"),".", ":"))*24 array entered (ctrl+shift+enter) and assuming there is no text in the range "Mick Stohr" <Mick wrote in message ... Want to add a column with hours and minutes as 5.32 meaning 5 hours and 32 minutes |
|
#5
|
|||
|
|||
|
The "--" (double unary minus) will coerce the text to numbers/times, so
if you included them, SUBSTITUTE() returning Text is not the problem. In article , "Mick Stohr" wrote: Must have done something wrong. get error message. The subsititute command seems to give text back so it can't be summed. Dont understand the arrray part. Would prefer using the period since its easier (so i am lazy-efficient). Would you elaborate? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding hours and minutes | Excel Worksheet Functions | |||
| Adding cells based on condition | Excel Worksheet Functions | |||
| pivot table with selection values not included in the base data | Charts and Charting in Excel | |||
| convert hours and minutes to minutes | Excel Discussion (Misc queries) | |||
| Adding minutes to time | Excel Discussion (Misc queries) | |||
Linear Mode
