the sheet may look
A B (total minutes)
11:40pm -- 12:20am {auto cal and population}
I can re-arrange data to make it easier for Excel to look like this
(using 24hour schema)
A B C (total
minutes)
R1 11:40 12:20 {auto cal and population}
The calculation formula or expression in C1 would have to be something
like ((The first element of B1, that is, 12) - (the first element of
A1, that is, 11);
then, * 60) - (the second element of A1 - the second element of B1,
that is, 20)
= 40
I'm not Excel guru, can you parse/extract partial data set from a cell
like above?
TIA.
should work for any period less than 24 hours. format the cell as general
to get the correct answer.
--
Regards,
Tom Ogilvy
=((HOUR(A1)+HOUR(B1))*60)+(MINUTE(A1)+MINUTE(B1))
Format as general.
Mike
Many thanks, your solution works like a cham.
Mike, sorry, yours doesn't, maybe I did not do something right (I
followed your suggested format as well).