Time Based Calculations

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jain_sanju - 11 Sep 2004 12:21 GMT

Signature

Sanjay Jain
Gurgaon
Haryana
India

Reply to this Message

Max - 11 Sep 2004 13:27 GMT

Try Chip's page at:
http://www.cpearson.com/excel/datetime.htm#AddingTimes

Signature

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----

Re: Time Based Calculations

> --
> Sanjay Jain
> Gurgaon
> Haryana
> India

Reply to this Message

Sandy Mann - 11 Sep 2004 13:32 GMT

That's not a whole lot to go on but if the times are entered as XL times
then mulitply the times by 24 to turn them into numbers that can be used in
calculations.

HTH

Sandy

Signature

to e-mail direct replace @mailintor.com with @tiscali.co.uk

Reply to this Message

Biff - 11 Sep 2004 22:05 GMT

Biff
Pittsburgh
Pennsylvania
U.S.A

>-----Original Message-----

Reply to this Message

JulieD - 13 Sep 2004 16:59 GMT

GMT +8hrs
Julie
Perth
Western Australia
Australia

> Biff
> Pittsburgh
> Pennsylvania
> U.S.A
>
> >-----Original Message-----

Reply to this Message

Sandy Mann - 13 Sep 2004 19:35 GMT

GMT + 1hr (British Summer? Time)
Sandy
Perth
Scotland

Signature

to e-mail direct replace @mailintor.com with @tiscali.co.uk

> GMT +8hrs
> Julie
[quoted text clipped - 8 lines]
> >
> > >-----Original Message-----

Reply to this Message