to calculate the difference between sign in and signout time in minutes.
 

I need help with formating the time with colon when time entered
without colon in to two different columns. Then calculate the
difference between two times.
For example:

enter in colum A Colum B
difference (in minutes)

850 converts to 08:50 855 convets to 08:55
5
855 08:55 900 09:00
5
1150 11:50 1158 11:58
8

Can anyone help me with this please?

Thanks
GG

to calculate the difference between sign in and signout time in minutes.
 

One way:

=(TEXT(B1,"0\:00")-TEXT(A1,"0\:00"))*1440

In article .com,
wrote:

I need help with formating the time with colon when time entered
without colon in to two different columns. Then calculate the
difference between two times.
For example:

enter in colum A Colum B
difference (in minutes)

850 converts to 08:50 855 convets to 08:55
5
855 08:55 900 09:00
5
1150 11:50 1158 11:58
8

Can anyone help me with this please?

Thanks
GG

to calculate the difference between sign in and signout time in mi
 

Format Column A and Column B as 00\:00

Formula in C1 =B1-A1 Format as general


" wrote:

I need help with formating the time with colon when time entered
without colon in to two different columns. Then calculate the
difference between two times.
For example:

enter in colum A Colum B
difference (in minutes)

850 converts to 08:50 855 convets to 08:55
5
855 08:55 900 09:00
5
1150 11:50 1158 11:58
8

Can anyone help me with this please?

Thanks
GG

to calculate the difference between sign in and signout time in minutes.
 

JE McGimpsey wrote:
One way:

=(TEXT(B1,"0\:00")-TEXT(A1,"0\:00"))*1440

In article .com,
wrote:

I need help with formating the time with colon when time entered
without colon in to two different columns. Then calculate the
difference between two times.
For example:

enter in colum A Colum B
difference (in minutes)

850 converts to 08:50 855 convets to 08:55
5
855 08:55 900 09:00
5
1150 11:50 1158 11:58
8

Can anyone help me with this please?

Thanks
GG

This seems to work. Appreciate your help. Will save enormous amount of
time.
Thanks amillion!!

to calculate the difference between sign in and signout time in mi
 

Teethless mama wrote:
Format Column A and Column B as 00\:00

Formula in C1 =B1-A1 Format as general


" wrote:

I need help with formating the time with colon when time entered
without colon in to two different columns. Then calculate the
difference between two times.
For example:

enter in colum A Colum B
difference (in minutes)

850 converts to 08:50 855 convets to 08:55
5
855 08:55 900 09:00
5
1150 11:50 1158 11:58
8

Can anyone help me with this please?

Thanks
GG

I tried this. But the problem is it does not calculate the difference correctly.
For example: 08:55 and 09:00, it gives me the difference of 45 instead
of 5.

Thanks a bunch.

to calculate the difference between sign in and signout time in mi
 

Changing the Formatting will not change the values stored in the cells
which are used in the calculation, so the values will not be treated as
times. If A1 = 850 and B1 = 915 the result would be 65, not 25.

In article ,
Teethless mama wrote:

Format Column A and Column B as 00\:00

Formula in C1 =B1-A1 Format as general