Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
If the period can exceed 24 hours then you need a date as well as a time for start and finish so in your start time cell (Say A1) enter:- 1/1/2007 06:00 In your end time cell (Say B1) enter 2/1/2007 22:00 now simply do a subtraction = B1-A1 Note that B1 is the later time. Format the cell as [hh]:mm and your done. Mike "Winkle Bill" wrote: I am new to spreadsheets and need to show the elapsed time between finishing and starting working periods, in hours and minutes, when these periods often exceed 24 hours -- Winkle Bill |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
If time Go to Function | Excel Worksheet Functions | |||
One-time NOW() function | Excel Worksheet Functions | |||
Time function | Excel Worksheet Functions | |||
Function to convert Time String to Time | Excel Worksheet Functions |