G
Guest
Frank, you are my absolute hero, I have been trying for ages to sort that one
out
(see question Timesheet Calculation, Richard Burrow) I new it would be
something simple like that.
I now have a further question however.
I have set the formatted the cell to show the hours worked as a number for
example:
Start time Finish Time Total Time
8:45 AM 9:00 AM 0.25
It is showing the time worked as 0.25 I appreciate that 0.25 represents a
quater of 1, but I want it to display the results as a quater of an hour i.e
0.15
how would this be achieved.
out
(see question Timesheet Calculation, Richard Burrow) I new it would be
something simple like that.
I now have a further question however.
I have set the formatted the cell to show the hours worked as a number for
example:
Start time Finish Time Total Time
8:45 AM 9:00 AM 0.25
It is showing the time worked as 0.25 I appreciate that 0.25 represents a
quater of 1, but I want it to display the results as a quater of an hour i.e
0.15
how would this be achieved.