114 reputation
2314
bio website
location
age
visits member for 4 years, 11 months
seen Apr 14 at 21:40

Jul
2
awarded  Curious
Dec
16
awarded  Notable Question
Jun
5
awarded  Famous Question
May
3
awarded  Popular Question
Mar
20
awarded  Popular Question
Dec
5
answered Anywhere Access with Windows Server 2012 Essentials
Dec
5
asked Anywhere Access with Windows Server 2012 Essentials
Jul
17
awarded  Popular Question
Jan
1
awarded  Nice Question
Dec
5
comment Excel elapsed time format
does anyone have a solution?
Nov
17
awarded  Commentator
Nov
17
comment Excel elapsed time format
my original question stated hours, but I believe the solution assumes the value is in days: [<0.04] [m]"m";[<1]h"h" m"m";d"d" h"h" m"m". I'm ok with assuming a month is a fixed number of days (e.g. 30 days per month).
Nov
16
awarded  Promoter
Nov
14
comment Excel elapsed time format
Is there a way to add months to this format? e.g. 1M 1d 1h 1m. The problem with the current format is it doesn't handle anything over 32 days (ie 32.5 is formatted as 1d 8h 0m)
Oct
26
comment Excel elapsed time format
absolutely awesome. Thanks! I see that it doesn't show days if it's less than 24 hours. any way to not show hours if it's less than 1 hour?
Oct
26
accepted Excel elapsed time format
Oct
26
asked Excel elapsed time format
Aug
30
awarded  Notable Question
Dec
11
comment Web Analytics on Intranet
thanks - will try this
Dec
3
awarded  Popular Question