Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
lest say you have 2 dates & times in A1 and B1
10/1/2007 22:00 in A1 31/1/2007 06:00 in B1 type =B1-A1 in another cell and right click that cell and then Format Cells|Number|Custom and type in a custom formt of [hh]:mm ensuring yopu remember the [] square brackets bit. Click OK Mike "Moist" wrote: Hi Mike, thank yu for the propt response, buit I'm totaslly green when it comes to spreadsheet, so caould you give me a litytle more advise. I have altered my cell referncec to hh:mm in cells B3 & C3 and I would like to see my results (to use the formulation you have advised) in cell D3, but I'm unsure hiow to complete the formular "=laterdate-earlierdate"? "Mike H" wrote: Hi, It depends how your dates are stored and these look suspicious with the @ sign in the middle. However on the assumption your dates are stored using a 'normal' type of format then its simple subtraction:- =laterdate-earlierdate with the cell formatted with [hh]:mm Mike "Moist" wrote: Hi, Would someone be so kind to advise me of the formular required to track the hours passed between two dates/time? i.e Start Date and Time = 01/01/07 @ 06:00 hrs End Date & Time = 03/01/07 @ 12:30 hrs = 54.5 hrs Thanks in advance for your help. Gary |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Tracking Time | Excel Worksheet Functions | |||
Tracking Time | Excel Discussion (Misc queries) | |||
Tracking time | Excel Worksheet Functions | |||
Tracking who accesses a spreadsheet | Excel Discussion (Misc queries) | |||
how to do a recruiting and tracking spreadsheet | Setting up and Configuration of Excel |