Calculating a runtime in Hours/Minutes.

[Johno]

Hi
In cell a1 I have a start time, E.g: 19:26. In cell a2 I have an end
time, E.g: 02:21. How do I calculate the actual runtime in
hours/minutes, E.g: 06:55 (Is that correct?) for cell a3? Also, if I
have a date in a cell, E.g: 28/2/2004, how can I produce the actual
day of the week in an adjoining cell, E.g: Sat.
I know this is probably a walk in the park for most of you but many
thanks for your help.
Johno

 

[Frank Kabel]

Hi Johno
1. Running time:
=A2-A1+(A2<A1)
and format the target cell as Time

2. Several solutions e.g. the date is in A2, enter the following in B2:
=A2 and format this cell with the custom format "DDD" (goto 'Format -
Cells - Custom). Internally Excel stores the complete date information
just the representation is changed
or
=TEXT(A2,"DDD) -> This will create a text value

 

[Norman Harker]

Hi Johno!

First:

=A2-A1+(A2<A1)
Format as time

Second

=B1
Format "ddd"

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.