calculate time

[Dear_Wies]

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

 

[Mike H]

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