ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How i can calculate time (https://www.excelbanter.com/excel-discussion-misc-queries/17209-how-i-can-calculate-time.html)

Rao Ratan Singh

How i can calculate time
 
Dear Anybody,
pls tell me that i have how i can calculate time in seven different cells

A B C D

12.35am 11.30pm 7.00Am 7.00 pm

What will be the total Hour and minute of these

Bernard Liengme

Please explain in more detail. Do you want the difference between each pair
of times?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Rao Ratan Singh" wrote in message
...
Dear Anybody,
pls tell me that i have how i can calculate time in seven different cells

A B C D

12.35am 11.30pm 7.00Am 7.00 pm

What will be the total Hour and minute of these




Ron de Bruin

Look here
http://www.cpearson.com/excel/overtime.htm

And
http://www.cpearson.com/excel/datetime.htm#AddingTimes


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Rao Ratan Singh" wrote in message
...
Dear Anybody,
pls tell me that i have how i can calculate time in seven different cells

A B C D

12.35am 11.30pm 7.00Am 7.00 pm

What will be the total Hour and minute of these





All times are GMT +1. The time now is 02:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com