[pigsy101]

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