| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time
Hello
Someone please help me to calculate different between times in different dates. Like A column B column 1.jan 09 11:15 3.jan 09 15:45 I need difference between these two times in Hour and minutes Thanks Pmss |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Time
=(A2+B2)-(A1+B1) and custom format result cell with format code [h]:mm
Regards, Stefi €˛pmss€¯ ezt Ć*rta: Hello Someone please help me to calculate different between times in different dates. Like A column B column 1.jan 09 11:15 3.jan 09 15:45 I need difference between these two times in Hour and minutes Thanks Pmss |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Time
Hi
Thanks but it did not work. It gives 3 hours but it must be 52:30. Regards Pmss "Stefi" wrote: =(A2+B2)-(A1+B1) and custom format result cell with format code [h]:mm Regards, Stefi €˛pmss€¯ ezt Ć*rta: Hello Someone please help me to calculate different between times in different dates. Like A column B column 1.jan 09 11:15 3.jan 09 15:45 I need difference between these two times in Hour and minutes Thanks Pmss |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Time
Check again, for me it gives 52:30!
Stefi €˛pmss€¯ ezt Ć*rta: Hi Thanks but it did not work. It gives 3 hours but it must be 52:30. Regards Pmss "Stefi" wrote: =(A2+B2)-(A1+B1) and custom format result cell with format code [h]:mm Regards, Stefi €˛pmss€¯ ezt Ć*rta: Hello Someone please help me to calculate different between times in different dates. Like A column B column 1.jan 09 11:15 3.jan 09 15:45 I need difference between these two times in Hour and minutes Thanks Pmss |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Time
thanks
but still problem. i could not set format code [h]:mm it gives error messege i can set only [t]:mm but gives 75:00 Pmss "Stefi" wrote: Check again, for me it gives 52:30! Stefi €˛pmss€¯ ezt Ć*rta: Hi Thanks but it did not work. It gives 3 hours but it must be 52:30. Regards Pmss "Stefi" wrote: =(A2+B2)-(A1+B1) and custom format result cell with format code [h]:mm Regards, Stefi €˛pmss€¯ ezt Ć*rta: Hello Someone please help me to calculate different between times in different dates. Like A column B column 1.jan 09 11:15 3.jan 09 15:45 I need difference between these two times in Hour and minutes Thanks Pmss |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Time
What language version do you use? What is hour and minute in your language?
Replace h by format code for hour in your language and m by format code for minute in your language! Stefi €˛pmss€¯ ezt Ć*rta: thanks but still problem. i could not set format code [h]:mm it gives error messege i can set only [t]:mm but gives 75:00 Pmss "Stefi" wrote: Check again, for me it gives 52:30! Stefi €˛pmss€¯ ezt Ć*rta: Hi Thanks but it did not work. It gives 3 hours but it must be 52:30. Regards Pmss "Stefi" wrote: =(A2+B2)-(A1+B1) and custom format result cell with format code [h]:mm Regards, Stefi €˛pmss€¯ ezt Ć*rta: Hello Someone please help me to calculate different between times in different dates. Like A column B column 1.jan 09 11:15 3.jan 09 15:45 I need difference between these two times in Hour and minutes Thanks Pmss |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Time
=CONCATENATE((DAY(A2-A1)*24)+HOUR(B2-B1),":",MINUTE(B2-B1))
Formatted as General or Number with zero decimals. There must be an easier way but this works. Lou "Stefi" wrote: Check again, for me it gives 52:30! Stefi €˛pmss€¯ ezt Ć*rta: Hi Thanks but it did not work. It gives 3 hours but it must be 52:30. Regards Pmss "Stefi" wrote: =(A2+B2)-(A1+B1) and custom format result cell with format code [h]:mm Regards, Stefi €˛pmss€¯ ezt Ć*rta: Hello Someone please help me to calculate different between times in different dates. Like A column B column 1.jan 09 11:15 3.jan 09 15:45 I need difference between these two times in Hour and minutes Thanks Pmss |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time calculations for Scheduled Time vs. Actual Time Worked | Excel Discussion (Misc queries) | |||
| straight time, time and a half, and double time | Excel Discussion (Misc queries) | |||
| Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
| Comparing 2 files on date/time stamp, and based time difference do a subroutine | Excel Programming | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Linear Mode
