Suppose A1 and A1 have you 'funny' times such as 2.15 and 3.45
The formula
=TIME(INT(A2),MOD(A2,1)*100,0)-TIME(INT(A1),MOD(A1,1)*100,0)+(A1A2)
will return the difference (in hours and mins). The last term allows for A2
being the next day and numerically less than A1.
You will need to format the cell as [h]:mm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Headacheaday" wrote in message
...
On our timesheets we must enter quarter hours as .15, .30, .45. Is there
a
way to
enter these decimals but have excel calculate them as .25, .50, .75.
Thanks,