time total and shell blank

  • Thread starter Thread starter BHAVESH.PATEL
  • Start date Start date
B

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
 
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
 
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
 
Back
Top