Display Text with Formulas

[Tim Steven]

I have 2 times and i want to display the difference between them in Hrs & Mins including the text "Hrs" & "Mins".

Example

Cell A1 Cell B1 Cell C1
8:00 12:30 4hrs 30mins

I am currently using =B1-A1 formula which gives me my correct answer displayed as 4:30 but i want to include the hrs and mins.

Any help would be great.

Thanks






Submitted via EggHeadCafe - Software Developer Portal of Choice
Hierarchical Relationships Without DataRelation
http://www.eggheadcafe.com/tutorial...9-48ead40566e2/hierarchical-relationship.aspx

 

[T. Valko]

You could use a custom format of:

h"hrs "m"mins"

The cell value will still be the numeric value of 0.1875 (4:30).

The problem with the custom format is stuff like this:

1hrs 1mins

Personally, I would want it to say:

1hr 1min