How to get difference between two times

**Climaxgp** · 11-03-2009, 07:21 AM

Hi Guys

I need a formula that gives me the difference between two different times

EG. 11:14:56 and 16:14:26, i want to find the difference/time between the two. Hope i'm making sense...

Also, does the time have to be in a time format on excel for the formula to work?

**DonkeyOte** · 11-03-2009, 07:26 AM

If the values are already time

C1: =B1-A1
format C1 to [mm]:ss etc (the [ ] implies cumulative - ie will go beyond 60)

If the values are text strings

C1: =B1-A1

ie the same... the act of subtraction will coerce the strings to numerical equivalent.

**Climaxgp** · 11-03-2009, 07:56 AM

Hi DonkeyOte

I know i marked the thread as solved, but i forgot to ask one more question..

Seeing as though i have the difference between the two times, i need a monetary value attached to the difference. How do i do that?

Our calls are charged at R1,35 a minute.

**DonkeyOte** · 11-03-2009, 08:03 AM

If you multiply the time difference by 1440 that will give you the time in decimal minutes against which you can multiply by R1,35 -- eg:

=(1440*(B1-A1))*1.35
(delimiter differences excepted)

so to be clear... multiplying time difference of say 36:30:15 seconds by the following factors

24 -> "Decimal" Hours -> 36.50416... (ie just over 36 1/2 hours - 1/2 hr being .5)
1440 -> "Decimal Minutes"-> 2190.25 (ie 2190 minutes and 1/4 minute)
86400 -> "Decimal Seconds" -> 131415 (131415 seconds)

Hope that makes sense.... obviously you can apply standard round up / down / nearest whole number techniques if you need to in terms of latter calculations.