Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time function
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time function
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |