Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculate time
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 calculate time between 2 date/time columns | Excel Discussion (Misc queries) | |||
Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
calculate hours using start time & end time, excluding weekends | Excel Programming | |||
IF statement to calculate time usage in specific time bands | Excel Worksheet Functions | |||
how to calculate time start & time finish in quarter hour | Excel Discussion (Misc queries) |