merge time field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mikesteven - 20 Jun 2006 19:27 GMT

I have an excel spreadsheet with a total time field and when I use it in the
format {mergefield tot_time \# "0.00;(0.00)"} I get 55.0 for one of the
participants instead of 5.50 when the excel data is 5:50. What do I need to
do to correct this. 8:00 shows correctly as 8.00.

Thannks,
Mike

Reply to this Message

Peter Jamieson - 20 Jun 2006 19:58 GMT

I'm not that familiar with Excel time data so don't know how you would get a
negative time, but if the time is being displayed as 5:50 then it is
arguably 5 hours 50 and "5.50" is arguably the wrong way to display it.

If the data in Excel is formatted as a time, you will need to use a
date/time switch (e.g. \@ "h:mm" or \@ "h.mm" ) to display it.

Peter Jamieson

>I have an excel spreadsheet with a total time field and when I use it in
>the
[quoted text clipped - 5 lines]
> Thannks,
> Mike

Reply to this Message