I just want to shear a formula which will help if you to calculate time stored as text for example

from | to |worked

1800 | 2400| 6

I searched the forum earlier and could not find anything simular

please note that the cell format for column A and B is custom 0000 in case values like 0100 have to be entered

the formula placed in c1 is:

=(INT(a1/100)+((a1-INT(a1/100)*100)/60))-(INT(B1/100)+((B1-INT(B1/100)*100)/60))

from | to |worked

1800 | 2400| 6

I searched the forum earlier and could not find anything simular

please note that the cell format for column A and B is custom 0000 in case values like 0100 have to be entered

the formula placed in c1 is:

=(INT(a1/100)+((a1-INT(a1/100)*100)/60))-(INT(B1/100)+((B1-INT(B1/100)*100)/60))

## Comment