Time calculation

**jazbath** · 06-09-2009, 01:07 PM

Hi,
I have in cell A1 date and time value (6/09/09 10:15)
Now I want to calculate the value of cell A2 taking only time value only (10:15) from A1, using IF. How can I write syntax asking to look only the time value not date? If time = 10:15, A1=1.33, 1.65 Is it possible? I tried it gives me #Value! error. Appreciate your help.
Thank you
Jaz

**DonkeyOte** · 06-09-2009, 01:08 PM

To get the time only

=MOD(A1,1)

**jazbath** · 06-09-2009, 01:22 PM

Thank you DonkeyOte, it gives me time value but I like to add 1.3 time value to this for A2.
Jaz

**DonkeyOte** · 06-09-2009, 01:42 PM

Jaz, I'm afraid I'm struggling to understand your wants... could you provide a few examples ?

**jazbath** · 06-09-2009, 02:15 PM

DonkeyOte,
I am attaching an example sheet, hope this would explain better.
Thank you for your time.
Jaz

**DonkeyOte** · 06-10-2009, 02:42 AM

Can you clarify as to what the 1.3 etc represents ? is 1.3 meant to be 1 and a 1/3 day - ie 30 hours or 1 and 1/3 hours ie 80 minutes ?

Also not clear if you want to add 1.3 to the datetime value in A1 or just the Time ? Assuming you mean to add 1.3 days to A1 if the time in A1 is 16:30 then:

A2: =A1+IF(MOD(A1,1)=0+"16:30",1.33,1.65)

**jazbath** · 06-10-2009, 01:50 PM

Hi DonkeyOte,
1.3 is the time value which is equal to about 32 hrs. Actually it is 1.3 days.
I am adding time to that value in A1. That works perfectly, all it does is add add 1.3 days to A1 date/time value and put in A2 changing both date and time accordingly.
thank you
Jaz