hi,,,,,
pls. help me how to calculate time difference in excel sheet suppose i have to calculate the diff between
10:00 to 10:40 then??????
10:00 to 11:40 then ?????
i want the diff. in minutes onlyyyyyyy
plzzzzzzzzzzzzz
Kumar Gaurav (Going...to be C.A soon...) (1624 Points)
17 January 2009hi,,,,,
pls. help me how to calculate time difference in excel sheet suppose i have to calculate the diff between
10:00 to 10:40 then??????
10:00 to 11:40 then ?????
i want the diff. in minutes onlyyyyyyy
plzzzzzzzzzzzzz
subasri
(searching for a job)
(54 Points)
Replied 20 December 2009
Type the times in two different cells.now in another cell type the formula =minute(first cell reference-second cell reference).you will get the answer in minutes.but this formula gives you the answer only if the difference is within 60 .if it exceeds 60,then the formula is =(first cell reference-second cell reference).
example:
B4=10:40
C4=10:00
then the formula is =minute(B4-C4),the ans is 40
if B4=11:40
C4 is =10:00
then the formula is =(B4-C4)*1440,the ans is 100.
subasri
(searching for a job)
(54 Points)
Replied 20 December 2009
if B4 =10:40,C4=10:00,the formula is =minute(B4-C4),the ans is 40.(this formula is used if the difference is within 60 minutes)
if B4=11:40,C4=10:00,the formula is =(B4-C4)*1440,the ans is 100(this formula is used if the difference is more than 60)
GSTR 9 and 9C for FY 23-24 as amended by Notification 12/2024 dated 10th July 2024(with recording)
CAclubindia
