Thread: calculate time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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