Asking for assistance: calculating a time difference

%3CLINGO-SUB%20id%3D%22lingo-sub-2719789%22%20slang%3D%22de-DE%22%3EAsking%20for%20assistance%3A%20calculating%20a%20time%20difference%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2719789%22%20slang%3D%22de-DE%22%3E%3CP%3EI%20have%20to%20calculate%20time%20gaps%20between%20a%20starting%20date%20and%20an%20end%20date.%20I%20have%20found%20the%20formula%20%3DDATEDIF%20(start%2C%20end%2C%22d%22)%20which%20is%20supposed%20to%20calculate%20the%20disered%20time%20gap%20in%20days.%3C%2FP%3E%3CP%3EBut%20all%20I%20get%20is%20an%20error%20message.%3C%2FP%3E%3CP%3EI%20'%20running%20WINDOWS%2010%20PRO%2C%20Version%2020H2%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20any%20helpful%20advice.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2719789%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2719812%22%20slang%3D%22en-US%22%3ERe%3A%20Asking%20for%20assistance%3A%20calculating%20a%20time%20difference%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2719812%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1146663%22%20target%3D%22_blank%22%3E%40MEAKMUC%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20calculate%20difference%20in%20days%20it's%20just%20%3CSTRONG%3E%3D%20end%20-%20start%3C%2FSTRONG%3E%20(%3DA2-A1)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2726339%22%20slang%3D%22en-US%22%3ERe%3A%20Asking%20for%20assistance%3A%20calculating%20a%20time%20difference%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2726339%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1146663%22%20target%3D%22_blank%22%3E%40MEAKMUC%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E44446%20is%20the%20serial%20number%20for%209%2F6%2F2021%3C%2FP%3E%3CP%3E44445%20is%20the%20serial%20number%20for%209%2F5%2F2021%3C%2FP%3E%3CP%3E%3D44446-44445%3C%2FP%3E%3CP%3Eor%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Yea_So_0-1630970211152.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308387iA725CC6889367722%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Yea_So_0-1630970211152.png%22%20alt%3D%22Yea_So_0-1630970211152.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Eor%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Yea_So_1-1630970323408.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308388iD644DE56BC5C900B%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Yea_So_1-1630970323408.png%22%20alt%3D%22Yea_So_1-1630970323408.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fdatedif-function-25dba1a4-2812-480b-84dd-8b32a451b35c%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EDATEDIF%20function%20(microsoft.com)%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have to calculate time gaps between a starting date and an end date. I have found the formula =DATEDIF (start, end,"d") which is supposed to calculate the disered time gap in days.

But all I get is an error message.

I ` running WINDOWS 10 PRO, Version 20H2

 

Thanks for any helpful advice.

 

3 Replies

@MEAKMUC 

To calculate difference in days it's just = end - start (=A2-A1)

@MEAKMUC 

 

44446 is the serial number for 9/6/2021

44445 is the serial number for 9/5/2021

=44446-44445

or

Yea_So_0-1630970211152.png

or

Yea_So_1-1630970323408.png

DATEDIF function (microsoft.com)

@MEAKMUC 

 


@MEAKMUC wrote:

But all I get is an error message.

Ah, the famous error message.