Software

Ask something
Question Locked

A Note from "Your Crowning Glory"

0 helpful
11 replies

by shirleynorton12

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am having problems with caluclating the
average time in excel h:mm see example. Not sure what I am doing wrong.
215.34
239.26
142.45
60.84
128.43
110.65
36.15
65.66
41.69
60.09
23.42
25.46
17.09
17.72
9.79
14.20
13.39
47.37

11 replies

by shirleynorton12

No, its the example of the numbers (elasped time) that I want the average of.

by shirleynorton12

The orginal document was exported to me. 2 columns with the date and 2 with time. I used a formula to combine a data and time, than subtracted one from the other to get elasped time (formatted it as a number). The next step was to find the average TAT in h:mm.

NOTE I have over 25,000 lines

by seanferd

and see if that sorts you.

edit to clarify:

you want that format for the output of your total time calculation, rather than the decimal format.

by thumbsup2

Once you convert time in hh:mm format to a decimal format, it's no longer a time. You need to maintain the hh:mm format throughout, including output of a query/formula which does time calculations, specifically elapsed time.

by older mycroft

It appears by inference that 'Crowning Glory' is something I [i]should[/i] recognise, but ...

What is it ? ?:|

by thumbsup2

Thought it might have something to do with the lesson materials! ;)

by seanferd

and possibly a hair-dresser's, going by top search results.

At first, I thought it sounded a bit like the name of a race horse.

Really, I've no clue, though.

This discussion is closed to new replies.