converting time to integer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ian - 02 Oct 2007 01:16 GMT

I'm need a difference in time as minutes for a pivot table. Here's the
problem. I've set a column (difference) as time1 - time2 and formated
difference as [mm] which shows me the correct number of minutes. I need to
convert this column to an integer so that I can group it in a pivot table
meaningfully. I've tried =text(difference, "000") but it doesn't work 483
minutes comes out as .34 blah, blah, blah -- I assuming it's giving me the
fraction of a day. How do I convert the text of the difference column into
an integer in the next column? Thanks Ian.

Reply to this Message

Pete_UK - 02 Oct 2007 01:42 GMT

You can do it directly from your time columns as follows:

=ROUND((time1-time2)*24*60,0)

Format the cell as number. Assumes time2 is earlier than time1.

Hope this helps.

Pete

> I'm need a difference in time as minutes for a pivot table. Here's the
> problem. I've set a column (difference) as time1 - time2 and formated
[quoted text clipped - 4 lines]
> fraction of a day. How do I convert the text of the difference column into
> an integer in the next column? Thanks Ian.

Reply to this Message

Ian - 02 Oct 2007 02:12 GMT

thanks Pete -- worked like a charm. Ian.

> You can do it directly from your time columns as follows:
>
[quoted text clipped - 14 lines]
> > fraction of a day. How do I convert the text of the difference column into
> > an integer in the next column? Thanks Ian.

Reply to this Message

Pete_UK - 02 Oct 2007 08:48 GMT

You're welcome, Ian - thanks for feeding back.

Pete

> thanks Pete -- worked like a charm. Ian.
>
[quoted text clipped - 18 lines]
>
> - Show quoted text -

Reply to this Message