| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Times
How do I add times (in minutes and hours) but show the total in days, hours
and minutes? This for a working day so a total of 9h15mins should display as 1d1h15mins. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding Times
=INT(A2*3)&"d "&TEXT(MOD(A2,1/3),"h:mm") would display as 1d 1:15
Adjust the formula to suit. -- David Biddulph "mudge55" wrote in message ... How do I add times (in minutes and hours) but show the total in days, hours and minutes? This for a working day so a total of 9h15mins should display as 1d1h15mins. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding Times
Thank you David. It worked like a charm.
"mudge55" wrote: How do I add times (in minutes and hours) but show the total in days, hours and minutes? This for a working day so a total of 9h15mins should display as 1d1h15mins. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding Times
Thank you David. Worked like a charm.
"David Biddulph" wrote: =INT(A2*3)&"d "&TEXT(MOD(A2,1/3),"h:mm") would display as 1d 1:15 Adjust the formula to suit. -- David Biddulph "mudge55" wrote in message ... How do I add times (in minutes and hours) but show the total in days, hours and minutes? This for a working day so a total of 9h15mins should display as 1d1h15mins. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding times again | New Users to Excel | |||
| adding times together | Excel Discussion (Misc queries) | |||
| adding times | Excel Discussion (Misc queries) | |||
| Adding up Times | Excel Worksheet Functions | |||
| Adding times | Excel Worksheet Functions | |||
Linear Mode
