| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
days and time functions
Dear
I requesting all who read this. start time 01 May 09 09:20:00 to 03 May 09 17:10:00 , reqired farmula for difference bewteen the time , answer required in the formate - days:hrs:mins:sec . Thanks regards. -- gv |
|
#2
|
|||
|
|||
|
Quote:
Forget the date format, Excel dates are sequential numbers Your result will be 2.32638888889051 What does this mean? You have 2 days and 0.32638888889051 time Assign a 37:30:55 time format to 0.32638888889051 and convert this decimal date code to 7:50:00 You have 2 days and 7:50:00 hours Done Last edited by John_Franco : May 4th 09 at 06:51 PM Reason: Forget detailes |
|
#3
|
|||
|
|||
|
Quote:
What does this mean? You have 2 days and 0.326388889 time Convert 0.326388889 to time format 37:30:55 for example and done Learn more about excel dates, visit: http://www.excel-spreadsheet-authors...xcel-date.html |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
days and time functions
With start date in A1 and end date time in A2, try the below
=TEXT(A2-A1,"dd hh:mm") If this post helps click Yes --------------- Jacob Skaria "raogv" wrote: Dear I requesting all who read this. start time 01 May 09 09:20:00 to 03 May 09 17:10:00 , reqired farmula for difference bewteen the time , answer required in the formate - days:hrs:mins:sec . Thanks regards. -- gv |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
days and time functions
OR A2-A1 and custom format the cell to dd:hh:mm:ss
If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: With start date in A1 and end date time in A2, try the below =TEXT(A2-A1,"dd hh:mm") If this post helps click Yes --------------- Jacob Skaria "raogv" wrote: Dear I requesting all who read this. start time 01 May 09 09:20:00 to 03 May 09 17:10:00 , reqired farmula for difference bewteen the time , answer required in the formate - days:hrs:mins:sec . Thanks regards. -- gv |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
days and time functions
=TEXT(A2-A1,"dd:hh:mm:ss")
If this post helps click Yes --------------- Jacob Skaria "raogv" wrote: Dear I requesting all who read this. start time 01 May 09 09:20:00 to 03 May 09 17:10:00 , reqired farmula for difference bewteen the time , answer required in the formate - days:hrs:mins:sec . Thanks regards. -- gv |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
days and time functions
my problem is solved. Thanks a lot sir.
-- gv "Jacob Skaria" wrote: =TEXT(A2-A1,"dd:hh:mm:ss") If this post helps click Yes --------------- Jacob Skaria "raogv" wrote: Dear I requesting all who read this. start time 01 May 09 09:20:00 to 03 May 09 17:10:00 , reqired farmula for difference bewteen the time , answer required in the formate - days:hrs:mins:sec . Thanks regards. -- gv |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
days and time functions
Please note that the TEXT() function will convert the format to text whereas
the below will not..... A2-A1 and custom format the cell to dd:hh:mm:ss If this post helps click Yes --------------- Jacob Skaria "raogv" wrote: my problem is solved. Thanks a lot sir. -- gv "Jacob Skaria" wrote: =TEXT(A2-A1,"dd:hh:mm:ss") If this post helps click Yes --------------- Jacob Skaria "raogv" wrote: Dear I requesting all who read this. start time 01 May 09 09:20:00 to 03 May 09 17:10:00 , reqired farmula for difference bewteen the time , answer required in the formate - days:hrs:mins:sec . Thanks regards. -- gv |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set my time and get rid of sample time using functions | Excel Worksheet Functions | |||
| Calculating time without using time functions... | Excel Worksheet Functions | |||
| Time between days | Excel Worksheet Functions | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
| date functions for previous 60/90/180 days | Excel Worksheet Functions | |||
Hybrid Mode
