Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|