calculate time
Hi,
First off you need a properly formatted start and end date and time in the
cell so enter a start/end date in the format
10/11/2007 22:30
To make it look like your dates apply a custom format of
yy/hh:mm
With a start date in A1 and an end date in b1, the formula
=B1-A1 will give you the time spent on a project
This cell should be formatted as
[hh]:mm
Mike
"Dear_Wies" wrote:
Dear All,
How can I count time when I wrote not a date/time format ex: start/fnsh at
6/22.30-7/05.40 in the same month, and how in the diffrent month?
Thanks alot
|