[pigsy101]

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

[Graham Mayor]

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 site www.gmayor.com
Word MVP web site http://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

[pigsy101]

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

[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

[macropod[_2_]]

Hi pigsy101,

A pair offields coded as:
{=INT(«MyTime») \# 0} hours and {=MOD(«MyTime»,1)*60 \# 0} minutes
will do the job.

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message. Likwise, you can't type the chevrons (ie '« »') - they're part of the actual mergefields, which you can
insert from the mailmerge toolbar.

--
Cheers
macropod
[Microsoft MVP - Word]


"pigsy101" wrote in message ...
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