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