time total and shell blank

[BHAVESH.PATEL]

sir,
i want to know about subtraction of time and addition of
time and also i want, any shell is not left blank you have
to write.
6:53 AM
6:49 AM
7:31 AM
6:12 AM
1:24 PM
7:59 AM
3:33 AM
7:59 AM
11:35 AM
11:39 AM
12:18 PM

total

bhavesh

 

[BHAVESH]

sir,
i want to know about time total , .
6:53 AM+6:49 AM+7:31 AM+6:12 AM+1:24 PM +7:59 AM +3:33
AM++7:59 AM++11:35 AM+11:39 AM +12:18 PM=total expro 60 hrs

bhavesh

 

[David McRitchie]

Then you already have your answer in my previous reply in this thread,
and since those are not times of day, I would format your times as
well as your total as previously mentioned to keep hours from
rolling off (and not showing) into days.
format, cells, custom: [h]:mm
If you included the days you would see where the other hours went
just so you can see it, not that you want to look at it this way.
format, cells, date, 03/14/98 13:30
your example will differ but note the hours show greater than 12:59
so it is not showing AM/PM. For your numbers your data will
show 01/02/00 (Jan 2, 1900 or 2 Jan 1900) representing 48 hours
and the time part will show the remaining hours and minutes.

Please reread my previous reply and the references, datetime.htm,
that I pointed to: one on my site the other on Chip Pearson's site.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm