| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculate difference of time
hello,
i have in a xls-sheet to rows formated as time (hh:mm) in each row the entries looks like 08:00 12:00 - 04:00 11:10 17:10 - 07:00 12:30 12:55 - 00:25 in the calculated column i want to have the difference between the two timestamps how can i do this. thank best regards |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
calculate difference of time
=B1-A1
-- Kind regards, Niek Otten "Xavier" wrote in message ... hello, i have in a xls-sheet to rows formated as time (hh:mm) in each row the entries looks like 08:00 12:00 - 04:00 11:10 17:10 - 07:00 12:30 12:55 - 00:25 in the calculated column i want to have the difference between the two timestamps how can i do this. thank best regards |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
calculate difference of time
thanks
"Niek Otten" wrote: =B1-A1 -- Kind regards, Niek Otten "Xavier" wrote in message ... hello, i have in a xls-sheet to rows formated as time (hh:mm) in each row the entries looks like 08:00 12:00 - 04:00 11:10 17:10 - 07:00 12:30 12:55 - 00:25 in the calculated column i want to have the difference between the two timestamps how can i do this. thank best regards |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate time difference | Excel Discussion (Misc queries) | |||
| Time Format and Calculate difference in time | Excel Discussion (Misc queries) | |||
| how to calculate time difference in hh:mm:ss | Excel Discussion (Misc queries) | |||
| how do i calculate the difference in time? | Excel Worksheet Functions | |||
| How do I calculate Time difference from PM to AM | Excel Discussion (Misc queries) | |||
Linear Mode
