Mail Marge Time formats
On Aug 5, 1:17*pm, pigsy101 wrote:
On Aug 5, 12:48*pm, "Graham Mayor" wrote:
You could use the following formulae
{= INT({ Mergefield MyTime })\# 0}hours and { =({ =MOD({ Mergefield
MyTime }, {= INT({ Mergefield MyTime })})} *60) \# 0 } minutes
All curly brackets are inserted with CTRL+F9.
--
Graham Mayor - *Word MVP
My web sitewww.gmayor.com
Word MVP web sitehttp://word.mvps.org
pigsy101 wrote:
Hi All.
I have mergefield which contains the total duration of a number of
interactions which is stored as a decimal value
e.g. 21.75
this is 21.75 hours and i need a way to convert this to 21 hours and
45 minutes.
I can convert this to minutes (*60) to get 1305 minutes but still
canno work out how to get this to hours and minutes.
Any help is very gratefully accepted.
Thanks- Hide quoted text -
- Show quoted text -
Thank you so much,
this is perfect
Thanks for your help- Hide quoted text -
- Show quoted text -
HI I have implemented this into the word doc but i get a syntax error
until i manually update the fields.
Is there a way around this?
pigsy101
|