Converting dd/mm/yyyy hr:min:sec in a column to fractional hour

[Ramesha]

Hi friends:

Looking for VBA support for calculating the time interval between two set(in two cells) of dd/mm/yyyy hr:min:sec in a column and convert the difference into fractional hours, right now I'm using four column shown below




Thanks in advance

 

[NARAYANK991]

Hi ,

I can only repeat what Hui has put up as a banner :

Upload a sample file with enough data , in all its variations.

Narayan

 

[Ramesha]

Hi ,

I can only repeat what Hui has put up as a banner :

Upload a sample file with enough data , in all its variations.

Narayan

enclosing the file as docx as I, can't upload xlsm

 

[NARAYANK991]

Hi ,

I am still not able to understand what you want , especially when you say you are using 4 columns. Column B contains the same data as column A.

Assuming that column A is your only column of data , then a formula such as the following should be enough :

=IF(ISNUMBER(A1),A2 - A1,0)*24

Enter this in B2 , and copy down.

Narayan

 

[Ramesha]

Super! Thanks