| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
counting hours from cell with time-table.
Is there any function (formula) in excel who gives me opportunity to count
how many hours there is between two pointet hours. An example: one cell indicate 09.30 - 16.00. In the oder cell I want to know how many hours there is beetwen the two hours (answe 6,5). -- Karl E Austvold |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
counting hours from cell with time-table.
=((D10-INT(D10))*24)-((C10-INT(C10))*24)
Which assumes your 2 times are in cells C10 & D10 "Karl E Austvold" wrote: Is there any function (formula) in excel who gives me opportunity to count how many hours there is between two pointet hours. An example: one cell indicate 09.30 - 16.00. In the oder cell I want to know how many hours there is beetwen the two hours (answe 6,5). -- Karl E Austvold |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
counting hours from cell with time-table.
=--TEXT(TRIM(MID(A21,FIND("-",A21)+1,99))*100,"00\:00")-TEXT(TRIM(LEFT(A21,FIND("-",A21)-1))*100,"00\:00")
and format as time. -- HTH Bob (change the xxxx to gmail if mailing direct) "Karl E Austvold" wrote in message ... Is there any function (formula) in excel who gives me opportunity to count how many hours there is between two pointet hours. An example: one cell indicate 09.30 - 16.00. In the oder cell I want to know how many hours there is beetwen the two hours (answe 6,5). -- Karl E Austvold |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
counting hours from cell with time-table.
Hell Karl,
Assuming you have 09.30 - 16.00 in cell A1 try this formula, format as number =MOD(RIGHT(SUBSTITUTE(A1,".",":"),5)-LEFT(SUBSTITUTE(A1,".",":"),5),1)*24 "Bob Phillips" wrote: =--TEXT(TRIM(MID(A21,FIND("-",A21)+1,99))*100,"00\:00")-TEXT(TRIM(LEFT(A21,FIND("-",A21)-1))*100,"00\:00") and format as time. -- HTH Bob (change the xxxx to gmail if mailing direct) "Karl E Austvold" wrote in message ... Is there any function (formula) in excel who gives me opportunity to count how many hours there is between two pointet hours. An example: one cell indicate 09.30 - 16.00. In the oder cell I want to know how many hours there is beetwen the two hours (answe 6,5). -- Karl E Austvold |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
counting hours from cell with time-table.
=(TIME(MID(A1,FIND("-",A1)+2,2),RIGHT(A1,2),0)-TIME(LEFT(A1,2),MID(A1,4,2),))*24
"Karl E Austvold" wrote: Is there any function (formula) in excel who gives me opportunity to count how many hours there is between two pointet hours. An example: one cell indicate 09.30 - 16.00. In the oder cell I want to know how many hours there is beetwen the two hours (answe 6,5). -- Karl E Austvold |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Hours from table based on date range... | Excel Discussion (Misc queries) | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Time sheets | Excel Worksheet Functions | |||
| calculate difference in time to hours | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
