Time

[pmss]

Hello
Someone please help me to calculate different between times in different
dates.

Like
A column B column
1.jan 09 11:15
3.jan 09 15:45

I need difference between these two times in Hour and minutes

Thanks
Pmss

 

[Stefi]

=(A2+B2)-(A1+B1) and custom format result cell with format code [h]:mm

Regards,
Stefi

„pmss†ezt írta:

 

[pmss]

Hi

Thanks but it did not work. It gives 3 hours but it must be 52:30.

Regards
Pmss

=(A2+B2)-(A1+B1) and custom format result cell with format code [h]:mm

Regards,
Stefi

„pmss†ezt írta:

Hello
Someone please help me to calculate different between times in different
dates.

Like
A column B column
1.jan 09 11:15
3.jan 09 15:45

I need difference between these two times in Hour and minutes

Thanks
Pmss

 

[Stefi]

Check again, for me it gives 52:30!
Stefi


„pmss†ezt írta:

Hi

Thanks but it did not work. It gives 3 hours but it must be 52:30.

Regards
Pmss

=(A2+B2)-(A1+B1) and custom format result cell with format code [h]:mm

Regards,
Stefi

„pmss†ezt írta:

Hello
Someone please help me to calculate different between times in different
dates.

Like
A column B column
1.jan 09 11:15
3.jan 09 15:45

I need difference between these two times in Hour and minutes

Thanks
Pmss

 

[pmss]

thanks
but still problem.
i could not set format code [h]:mm it gives error messege i can set only
[t]:mm but gives 75:00

Pmss

Check again, for me it gives 52:30!
Stefi


„pmss†ezt írta:

Hi

Thanks but it did not work. It gives 3 hours but it must be 52:30.

Regards
Pmss

=(A2+B2)-(A1+B1) and custom format result cell with format code [h]:mm

Regards,
Stefi

„pmss†ezt írta:

Hello
Someone please help me to calculate different between times in different
dates.

Like
A column B column
1.jan 09 11:15
3.jan 09 15:45

I need difference between these two times in Hour and minutes

Thanks
Pmss

 

[Stefi]

What language version do you use? What is hour and minute in your language?
Replace h by format code for hour in your language and m by format code for
minute in your language!
Stefi


„pmss†ezt írta:

thanks
but still problem.
i could not set format code [h]:mm it gives error messege i can set only
[t]:mm but gives 75:00

Pmss

Check again, for me it gives 52:30!
Stefi


„pmss†ezt írta:

Hi

Thanks but it did not work. It gives 3 hours but it must be 52:30.

Regards
Pmss

:

=(A2+B2)-(A1+B1) and custom format result cell with format code [h]:mm

Regards,
Stefi

„pmss†ezt írta:

Hello
Someone please help me to calculate different between times in different
dates.

Like
A column B column
1.jan 09 11:15
3.jan 09 15:45

I need difference between these two times in Hour and minutes

Thanks
Pmss

 

[Rookie 1st class]

=CONCATENATE((DAY(A2-A1)*24)+HOUR(B2-B1),":",MINUTE(B2-B1))
Formatted as General or Number with zero decimals.
There must be an easier way but this works.
Lou

Check again, for me it gives 52:30!
Stefi


„pmss†ezt írta:

Hi

Thanks but it did not work. It gives 3 hours but it must be 52:30.

Regards
Pmss

=(A2+B2)-(A1+B1) and custom format result cell with format code [h]:mm

Regards,
Stefi

„pmss†ezt írta:

Hello
Someone please help me to calculate different between times in different
dates.

Like
A column B column
1.jan 09 11:15
3.jan 09 15:45

I need difference between these two times in Hour and minutes

Thanks
Pmss